VLOOKUP?

K

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?
 
R

Ron Coderre

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

Does that help?

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

vezerid

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

HTH
Kostis Vezerides
 
A

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
 
A

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)
 
V

vezerid

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

Kostis Vezerides
 
Top