VLOOKUP with multiple sheet

tharusha · Jan 5th 2021

Hi

i have a workbook with 3 sheets call sheet1 ,sheet2 ,sheet3 and all table have a column call "code" and how can i get the "code" column values of sheet2 and sheet3

to sheet 1 "code1" column

can some one help

**Carim** · Jan 5th 2021

Hi,

Could you clarify your question ... and your final objective ...

Indeed, the 'Code' column in each worksheet does not contain the same codes ... so the matching cannot be built ...

tharusha · Jan 5th 2021

hi Carim

i m trying to check if this column named "code" values contain any of the sheets 2,sheet3
if so bring that code to sheet 1 and paste in code1 column

**Carim** · Jan 5th 2021

Hi again,

Attached is your test file ...

Not very clear which precise data you do need to bring back to the Sheet 1 ...

Hope this will help you

**Carim** · Jan 6th 2021

Thanks for your Like

VLOOKUP with multiple sheet

Participate now!

Share

Tags