excel lookups

[Bob]

Hi
I have a WorksheetA with col1 and col2 and WorksheetB within the same file
which has col1 values and col2 is empty. I would like to bring corresposding
col2 values from worksheetA to WorksheetB col2.

Ex:
A B
col1 col2 col1 col2
1 ' A' 1



I have to get value 'A' from worksheet A to B if A.col1=B.col1.

Please inform.

 

[Jake Marx]

Hi Bob,

Hi
I have a WorksheetA with col1 and col2 and WorksheetB within the
same file which has col1 values and col2 is empty. I would like to
bring corresposding col2 values from worksheetA to WorksheetB col2.

Ex:
A B
col1 col2 col1 col2
1 ' A' 1


I have to get value 'A' from worksheet A to B if A.col1=B.col1.

Take a look in help at the VLOOKUP worksheet function. It will do what
you're looking for. Something like this formula for WorksheetB/Col2
(assuming your range on WorksheetA is in A1:B10):

=VLOOKUP(A1, WorksheetA!$A$1:$B$10, 2, False)

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]