Index, Match??

[Richard]

Sheet2 has a list of all my part numbers in Column A and the surface
areas in Column B. I'd like when I input a part number on Sheet1 on
Column A for it to match the part number on Sheet 2 and put whats in
Sheet 2 Column B on Sheet1 Column B. Thanks in advance

 

[Pete_UK]

Assuming that your part number is in A2 of Sheet1, put this in B2:

=IF(A2="","",IF(ISNA(VLOOKUP(A2,Sheet2!A:B,2,0)),"not
present",VLOOKUP(A2,Sheet2!A:B,2,0)))

That will handle errors of non-matching part numbers.

Hope this helps.

Pete