How do I populate cells on sheet1 with data on sheet3 using data in sheet2?

[AdiB]

Hi, can anyone help with the following...

I have three worksheets: Sheet 1 and 2 contain identical tables except sheet 2 contains data within the table. Sheet 3 contains a key in column A (data in sheet 2) and B (what the data in sheet 2 needs to represent on sheet 1).

I would like...
Cell on sheet 1 to look at data in corresponding cell on sheet 2, i.e. M4 sheet 1 looks at M4 sheet 2 which contains 'L3'

Match that data on sheet 2 with data in column A on sheet 3, i.e. find 'L3' within data in column A on sheet 3.

Populate cell on sheet one with value in column B on same row as data found in column A sheet 3, i.e. 'L3' appears in column A row 12, populate M4 sheet 1 with value in sheet 3 column B row 12.

I tried to do a vlookup formula but it didn't work, either the formula was wrong or it isn't a vlookup I should be doing!?

Thanking you in anticipation!

AdiB

[royUK]

can yo attach the workbook?

[AdiB]

See attached, thank you.

AdiB

p.s. on last description should read column A row 14 (not 12) and column B row 14 (not 12)!

[VBA Noob]

Maybe

=VLOOKUP(Sheet2!C4,Sheet3!$A$1:$B$23,2,FALSE)

VBA Noob

[AdiB]

That works perfectly, thank you for your help.

Enjoy the rest of your Sunday.

AdiB