vlookup

  • Thread starter Thread starter tompe
  • Start date Start date
T

tompe

having trouble with vlookup. creating data in sheet 3 by looking up par
number in sheet 1 and 2 and returning data to sheet 3. Getting n/a.
know that the part number is in sheet 1 and 2 and that there are value
in the cells that I require. The problem is the formatting in eac
sheet is different. How do I change the formattting in bothe sheets t
the same? Is ther an easy way? is there a way around it
 
What formula are you using? You probably need to have the last
argument of the VLOOKUP set to FALSE. E.g,

=VLOOKUP(A1,'Sheet2'!A1:B10,2,FALSE)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top