Matching Values From Two Columns

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
 
K

Ken Wright

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index match with multiple criteria(different than usual) 0
Index match with multiple criteria(different than usual) 3
Comparing columns from 2 different worksheets. 1
Index/Match Functions to Return Concatenated Response 4
DBSUM function but with function as criterion, not a range 3
Match and delete rows on two different sheets from reference numbers 4
sumif to return an intersection? 17
Finding the proper style field and the numbered paragraph value within the style 0

Top