Lookup will 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.

Here is what the 2 spreadsheets look lke:


WORKSHEET #1

Stock code .......... Quantity
2247......................15
2248 ...................... 15
2250 ...................... 30
2251 ...................... 10
2252 ...................... 15

2253 ...................... 11

WORKSHEET #2

Stock code .......... Quantity
2247 ...................... 10
2248 ...................... 15
2251 ...................... 10
2252 ...................... 15








If anyone can help I will be eternally grateful.

Thanks in advance
 
I think he was addressing the audience at Exceltip.com as being his first
post there, perhaps not realizing it would be posted here too.
 
Lookup WILL work for this. First, start in column 3 (c) of spreadsheet 1.

The lookup help file in excel (f1, then type vlookup in the index tab) will
show you the syntax to use, this is a simple vlookup.

the value to lookup will be Spreadsheet1 column A, row whatever
the lookup range will be Spreadsheet2, column B, rows whatever to whatever
(use $ around them so they stay the same as you copy)
the returned value will be from Spreadsheet2, and what you refer to as: "a
value from a different column in spreasheet #2"-- and this would be a
number, e.g. 2 if the data you want to return is 2 columns over from the
lookedup value (which looks like a number like 2247).
 
Thanks very much. I finally got it to work after playing around with the
"true/false and the colum # reference for the result to be inserted.

Bruce
 
Back
Top