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?

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

Does that help?

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


" wrote:

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?

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

HTH
Kostis Vezerides

Hi

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


Arvi Laanemets


wrote in message
ups.com...
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?

Have tried all 3 and none worked :(

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

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

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


--
anar_baku
------------------------------------------------------------------------
anar_baku's Profile: http://www.excelforum.com/member.php...o&userid=18259
View this thread: http://www.excelforum.com/showthread...hreadid=489086

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

Kostis Vezerides