Compare lists

[Nemesis]

I have two worksheets. I want to compare a list in sheet 2 with a value
in sheet 1. If the value is found in the list, let's say in cell A1, I
want to extract the content in cell A2 and paste it into a cell in
sheet 1. Confusing?!!

 

[Max]

Perhaps a HLOOKUP (just an intuitive guess) ?

Example:

In Sheet2, assume the "list" is in A1:E2, where A1:E1 houses the values to
be looked-up (compared) and A2:E2 contains the values to be returned

In Sheet1, assume the lookup values are in A1 down
Put in say, B1: =HLOOKUP(A1,Sheet2!$A$1:$E$2,2,0)
Copy B1 down

 

[Guest]

If your list is in columns A and B on Sheet2, and your value to be searched
for is on Sheet1 in cell A1, put this in Sheet1 cell B1

=VLOOKUP(A1,SHEET2!A:B,2,FALSE)

Vaya con Dios,
Chuck, CABGX3

 

[Nemesis]

I'm sorry I haven't posted a "Thank you" post until now. But here it is
Thank you, guys

 

[Max]

You're welcome (from us) !
Thanks for the feedback ..
(Better late than never <g>)