Vlookup?

  • Thread starter Thread starter Steve B
  • Start date Start date
S

Steve B

Hello,

Thanks in advance for your help I think I need Vlookup.

I have 2 spreadsheets with customer numbers. I need to
look at each customer number from the first column in
spreadsheet 1. Then I need to find if that customer number
exists in spreadsheet two, and if it does,information from
a cell 2 cells over needs to be copied. The information
will be placed in a third sheet, ie customer number in 1
cell, and "Sales data" in the cell next to it.

Any help? Thank you!
 
Steve,

Customer Number

=Sheet1!A1, etc

Sales Data

=IF(NOT(ISERROR(VLOOKUP(A1,Sheet2!$A$1:$C$100,3,FALSE))),VLOOKUP(A1,Sheet2!$
A$1:$C$100,3,FALSE,"")



--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top