Combining two work sheets using a column in both as a key

T

TwoTone

Hello,
I've read about Vlookup and other functions, but none seem able to do what I
need.

In my first worksheet I have a column E that has a list of numbers, some are
listed more than once.

In the second work sheet I have the same numbers in column A, except they
are unique. This worksheet has a column B which has numbers related to A.
Sort of a master list.

I want to bring the value of B into the first worksheet where ever the
number in A matches the number in E.

Did I explain this well enough? Is it possible?
 
D

DaveT

If I understand correctly try this in the first cell you want the value to
return to

=VLOOKUP(E1,Sheet2!$A1:$B23,2)

where E1 is the first cell in column E that has data
Sheet2 is the name of your second sheet
$A1:$B23 is the range of columns that you want to reference
2 is the offset

Dave
 
Top