IF Help

R

raspywench

I am trying to find the right formula for the following:

If Name in Column A on Sheet 1 matches the Name in Column A on Sheet 2,
I want the adjacent results from Column B on Sheet 2 to show in Column B
on Sheet 1.

The name columns do not necessarily have the same information in them.

Any help would be appreciated!

Thanks!
 
G

Govind

Hi,

Use Vlookup formula. For eg. if your range in Sheet 2 is from A1 to B100
and you want the data in column B of Sheet 2 to appear once the name
column in sheet 1 and sheet 2 are matched, use

=VLOOKUP(A1,Sheet2!A1:B100,2,FALSE)

Govind.
 
Top