using vlookup - how do I match 2 spreadsheets w/o same exact numb.
 

I have 2 spreadsheets. 1 is my customers inventory and Year To Date sales the
other is my West Coast sales history. His spreadsheet does not have all of
the numbers my sheet has. I'm able to get the first matching number to bring
his sales history over but in vlookup the second numbers do not match so I
get a NA.

Try testing one number on your sheet against a matching number on another
sheet. Set the cell with withe the first number equal to the cell in the
second sheet via a formula like this:

=A1=[Book2]Sheet1!$A$1

If the formula returns TRUE, then you have a problem with your VLOOKUP
formula. If it returns FALSE, then although the data may look the same it's
really not. There may be a leading to trailing space in the data, etc.
Apply the TEXT, VALUE, and/or TRIM functions until you get a TRUE from the
lookup formula.

----
Regards,
John Mansfield
http://www.pdbook.com


----
Regards,
John Mansfield
http://www.pdbook.com


"klondike47" wrote:

I have 2 spreadsheets. 1 is my customers inventory and Year To Date sales the
other is my West Coast sales history. His spreadsheet does not have all of
the numbers my sheet has. I'm able to get the first matching number to bring
his sales history over but in vlookup the second numbers do not match so I
get a NA.