Lookup will not work

[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

 

[J.E. McGimpsey]

Hi, This is my first posting.

No, it's not. See answers to your previous post.

 

[Ken Wright]

rotflmao

 

[Dave R.]

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.

 

[Dave R.]

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).

 

[Bruce]

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