Hi all,

I am trying to figure the LOOKUP functions that exist in Excel, but I must
be very dumb, because I can not make it work as I want.

This is my scenario:

In one Worksheet (sheet1) it looks like this:
Column A: UserID
Column B: Firstname
Column C: Lastname
Column D: email

In the other Worksheet (sheet2) it looks like this:
Column A: Name (firtsname + lastname)
Column B. email

Here is what I want to achieve:
I Sheet2, I want under Column C a LOOKUP function that will do the follwoing:
Take the value from Sheet2!Column B, search in Sheet1!Column D and if there
is a MATCH, copy from that ROW, Column A (the UserID). If there is not match
at all, searching through the "array", it should just state "No UserID".

How on heavens Earth do I get this going?

Thank you all in advance that will take your knowledge, skills and time to
provide me with a solution and answer.

--Andreas

Hi Andreas,

Lookup's does not look to the left columns, copy the user id to an auxiliar
collumn on the sheet1 E for eg and try:

=if(iserror(vlookup(b2,sheet1!$d$2:$e$1000,2,0))," No User
ID",vlookup(b2,sheet1!$d$2:$e$1000,2,0))

offset and match funcions embeded could also help you, and you will find a
lot of samples on the Mr Chip Pearson web site at
www.cpearson.com/excel.htm

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Andreas B" escreveu:

Hi all,

I am trying to figure the LOOKUP functions that exist in Excel, but I must
be very dumb, because I can not make it work as I want.

This is my scenario:

In one Worksheet (sheet1) it looks like this:
Column A: UserID
Column B: Firstname
Column C: Lastname
Column D: email

In the other Worksheet (sheet2) it looks like this:
Column A: Name (firtsname + lastname)
Column B. email

Here is what I want to achieve:
I Sheet2, I want under Column C a LOOKUP function that will do the follwoing:
Take the value from Sheet2!Column B, search in Sheet1!Column D and if there
is a MATCH, copy from that ROW, Column A (the UserID). If there is not match
at all, searching through the "array", it should just state "No UserID".

How on heavens Earth do I get this going?

Thank you all in advance that will take your knowledge, skills and time to
provide me with a solution and answer.

--Andreas

Hi Marcelo!!

Thank you so much, this solved it all and gave me exactly what I wanted it
to be!!

Sincerely,
Andreas

"Marcelo" skrev:

Hi Andreas,

Lookup's does not look to the left columns, copy the user id to an auxiliar
collumn on the sheet1 E for eg and try:

=if(iserror(vlookup(b2,sheet1!$d$2:$e$1000,2,0))," No User
ID",vlookup(b2,sheet1!$d$2:$e$1000,2,0))

offset and match funcions embeded could also help you, and you will find a
lot of samples on the Mr Chip Pearson web site at
www.cpearson.com/excel.htm

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Andreas B" escreveu:

Hi all,

I am trying to figure the LOOKUP functions that exist in Excel, but I must
be very dumb, because I can not make it work as I want.

This is my scenario:

In one Worksheet (sheet1) it looks like this:
Column A: UserID
Column B: Firstname
Column C: Lastname
Column D: email

In the other Worksheet (sheet2) it looks like this:
Column A: Name (firtsname + lastname)
Column B. email

Here is what I want to achieve:
I Sheet2, I want under Column C a LOOKUP function that will do the follwoing:
Take the value from Sheet2!Column B, search in Sheet1!Column D and if there
is a MATCH, copy from that ROW, Column A (the UserID). If there is not match
at all, searching through the "array", it should just state "No UserID".

How on heavens Earth do I get this going?

Thank you all in advance that will take your knowledge, skills and time to
provide me with a solution and answer.

--Andreas

Glad to help.

thanks for the feedback
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Andreas B" escreveu:

Hi Marcelo!!

Thank you so much, this solved it all and gave me exactly what I wanted it
to be!!

Sincerely,
Andreas

"Marcelo" skrev:

Hi Andreas,

Lookup's does not look to the left columns, copy the user id to an auxiliar
collumn on the sheet1 E for eg and try:

=if(iserror(vlookup(b2,sheet1!$d$2:$e$1000,2,0))," No User
ID",vlookup(b2,sheet1!$d$2:$e$1000,2,0))

offset and match funcions embeded could also help you, and you will find a
lot of samples on the Mr Chip Pearson web site at
www.cpearson.com/excel.htm

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Andreas B" escreveu:

Hi all,

I am trying to figure the LOOKUP functions that exist in Excel, but I must
be very dumb, because I can not make it work as I want.

This is my scenario:

In one Worksheet (sheet1) it looks like this:
Column A: UserID
Column B: Firstname
Column C: Lastname
Column D: email

In the other Worksheet (sheet2) it looks like this:
Column A: Name (firtsname + lastname)
Column B. email

Here is what I want to achieve:
I Sheet2, I want under Column C a LOOKUP function that will do the follwoing:
Take the value from Sheet2!Column B, search in Sheet1!Column D and if there
is a MATCH, copy from that ROW, Column A (the UserID). If there is not match
at all, searching through the "array", it should just state "No UserID".

How on heavens Earth do I get this going?

Thank you all in advance that will take your knowledge, skills and time to
provide me with a solution and answer.

--Andreas