A Lookup function does not work

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

Hi, This is my first posting.

I am using Exel 2000. I have 2 separate spreadsheets that have some
similar columns but not all of the data in the similar columns is the
same.

What I want to do is take column A in spreadsheet#1 and find this same
value in Column B in Spreadsheet#2 and then insert into column 3 in
spreadsheet #1 a value from a different column in spreasheet #2 that
corresponds to the row in which the value was looked up in Column B in
spreadsheet#2.

What I am doing is comparing 2 different inventory files that have
stock codes in columns and quantities in another column, but not
necessarily all the same stock codes are in each file and neither file
has a complete listing of all stock codes. Where the stock code is the
same, I want to insert the quantity from file 2 into file 1 so that I
can compare the two.

If anyone can help I will be eternally grateful.

Thanks in advance
 
Hi Bruce:

You question is a little confusing. You use "Column A" at
one point and then "Column 3" at another. But I think you
want a function like VLookup. The function is something
like (you put it into column 3 of sheet 1):

=vlookup (sheet1!a1, sheet2!b1:c100, 2, False)

But actually, I think you are better off moving everything
in Access.

If you want, I can email you an excel file with fake data
that does the work, assuming that I understood the
question correctly.

Dom
 
One way:

In sheet1:

C1: =VLOOKUP(A1, Sheet2!B:D,3,FALSE)

where 3 corresponds to the third column in the range B:D, or column
D's value.
 
Back
Top