Match 2 Columns and Popluate Another

G

Guest

I am in desperate help.

I have a spreadsheet with 2 tabs. Both tabs have item ID's in the first
column. The second columns contain different data. I need to match the
items in the first column on the first tab to the first column on the second
tab, and if they match retrieve the information from the second tab, second
column to be placed on the first tab, third column.

Thank you.
 
G

Guest

One way

Assume data starts in row2 down

In Sheet1,

Put in C2:
=IF(ISNA(MATCH(A2,Sheet2!A:A,0)),"",INDEX(Sheet2!B:B,MATCH(A2,Sheet2!A:A,0)))
Copy down as far as required
 

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

Macro: finding a cell on one worksheet and copying to another worksheet 0
Excel Excel: Match, Index and subtract across 2 columns and 2 tabs 2
Index/match across multiple columns? 19
IF Statement Problem 4
Look Up 2 Values, Match 2 Values Different Tab Return 3rd Value 4
A conditional lookup question. 5
Count Based on Comparison with Two Fields 2
Vlookup using 2 criteria 2

Top