View Single Post
  #1   Report Post  
klondike47
 
Posts: n/a
Default 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.