VLOOKUP?

[k.roberts]

I have 2 worksheets - Sheet1 contains a list of ID numbers in column A,
contact names in column B. Sheet2 contains a list of ID numbers - some
of which will match those in Sheet1, with email address next to them.
I want to create a formula for Sheet1 which will look at the ID number
in cell A1 in Sheet1, search in Sheet2 for the corresponding ID and
bring the relevant email address forward into Sheet1. How do I do this?

 

[Guest]

Try this:
On sheet 1:
A1: (ID num)
C1: =VLOOKUP(A1,Sheet2!A:B,2,0)

Does that help?

***********
Regards,
Ron

 

[vezerid]

in Sheet1:
=IF(NOT(ISNA(VLOOKUP(A1, Sheet2!A:B, 2, 0))), VLOOKUP(A1, Sheet2!A:B,
2, 0), "")

HTH
Kostis Vezerides

 

[Arvi Laanemets]

Hi

Like
=IF(ISERROR(VLOOKUP(A2,Sheet1!$A$2:$B$100,2,0)),"",VLOOKUP(A2,Sheet1!$A$2:$B
$100,2,0))


Arvi Laanemets

 

[k.roberts]

Have tried all 3 and none worked

 

[anar_baku]

Try this, but _first_of_all_ sort your ID column in ascending order i
Sheet 2:

C1: =VLOOKUP(A1, Sheet2!A1:C8, 2, FALSE)

Where A1:B8 is all the data in Sheet2 that you want to search throug
and 2 is the number of the column where emails are listed (column B
assume)

 

[vezerid]

What do you mean they have not worked? Do they produce incorrect
values? #N/A? Please be more specific.

Kostis Vezerides