Matching Values From Two Columns

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

Hypothetical: I have two worksheets. Worksheet1 with
Column1:Part Numbers, Column2:Price; and Worksheet2 with
Column1:Part Numbers, Column2: Description. I want these
sheets to be merged into one sheet and have the items line
up according to Part #. The main issue being that not all
part numbers from Worksheet1 are on Worksheet2. So my
resulting sheet should look like this:

Part#, Price, Part#, Decription
1, $5, 1, tacos
2
3
4, $4, 4, washboards
5
6, $2, 6, tin
 
Assuming you select data in the 2 columns of your sheet 2 and name it Table2 using Insert / Name /
Define, then on sheet 1 in cell C1 put the following formula and copy down:-

=IF(ISNA(VLOOKUP(A1,Table2,2,0)),"",VLOOKUP(A1,Table2,2,0))
 
Back
Top