user2315964
user2315964

Reputation:

How to match data on separate sheet then return adjacent data to the cell matched?

I have data in A1 in 'sheet1'.

I have data in A1 and C1 on 'sheet2'.

The result and formula will be in cell B1 in 'sheet1'.

I need the formula in cell B1 on 'sheet1' to match up A1 (sheet1) to A1 on sheet2 (that's the easy bit! I can do that no problems with the lookup and reference tab) but instead I want the return value to match up A1 on sheet2 but return the value from C1 on sheet2 instead.

I can't do this, please help?

Upvotes: 0

Views: 299

Answers (1)

pnuts
pnuts

Reputation: 59450

Perhaps =VLOOKUP(A1,Sheet2!A:C,3,FALSE)

Upvotes: 1

Related Questions