Please help me with a VLOOKUP

[leigh_ashlin]

Hi there,

I have 2 columns of data:

Worksheet 1 Column A
Worksheet 2 Column C

I need to find which values in Worksheet 2 Column C, match the values in Worksheet 1 Column A.

I really, really don't know how to do this and have fiddled around with VLOOKUP for a while without success.

Can somebody please help me?

 

[PaddyD]

have a look here:

http://www.cpearson.com/excel/duplicat.htm

 

[Artorius]

Firstly, name the range in Column A in Worksheet 1.

To do this, highlight column A in Worksheet 1, click on Insert, then on Name, then type in a name ... lets call it TEST.

In Column D in Worksheet 2, type in the following formula, assuming the first data in Column C that you want to look up is in cell C2:-

=VLOOKUP(C2,TEST,1,FALSE)

If excel finds a match in Column C2 of Worksheet2 in Column A of Worksheet1 ... it will return the value in Column A of Worksheet 1 in cell D2. If there is no match, you will get a #N/A.

If you do not want the #N/A's on your worksheet .... change the formula to the following:-

=IF(ISNA(VLOOKUP(C2,TEST,1,FALSE)),"",VLOOKUP(C2,TEST,1,FALSE))

Hope this helps.