Vlookup in another worksheet

[vicmar]

hi



I need help regarding my vlookup i have 6 worksheet and i need to compare the reference from the master list. I attached the sample of my excel

thank you in advance

[NBVC]

First create a list of all your sheets somewhere in the Master List (you can hide the column afterwards)....

So, assuming you created this list in Master List!P2:P6, enter formula in Master List, C2:

=IF(F3="","",VLOOKUP(F3, INDIRECT("'"&INDEX($P$2:$P$6, MATCH(TRUE, COUNTIF(INDIRECT("'"&$P$2:$P$6&"'!$B$3:$B$17"),F3) >0,0))&"'!$B$3:$C$17"),2,0))

confirm with CTRL+SHIFT+ENTER not just ENTER.

[vicmar]

Hi thank for your response. What do you mean create list in the column of master list?

the name of the sheet?

What Im trying to do is for example in Sheet A Column E should be equal in Master List column B if Master List Column F is equal to Sheet A Column B.

I try this formula but its not working in other sheets:

=IF(a!B3='Master List'!F3,'Master List'!B3,"")

[Pecoflyer]

Again, this is a well-known and well-documented problem addressed a zillion times on the Net.
In the future please user your browser first to do some research.
Cheers

[NBVC]

See attached.

In P2:P6, I listed the names of your lookup sheets..

[vicmar]

my mistake maybe my question a bit confusing.

I attached the sample of what I want to do and enter the data manually the formula should be in every Sheet of Column E except the master list.

thank you

[NBVC]

Ok.

Try this formula in E3 of each sheet, copied down:

=IFERROR(INDEX(OUT[REF. NO.],MATCH(B3,OUT[INCOMING REF. NO.],0)),"")

[vicmar]

now its ok the only problem that i made is that my formula is per row not per column.

anyway thank you very much @NBVC.

how can i put the status solved in the thread?

[Pecoflyer]

Done ( it's under " thread Tools" normally)

[vicmar]

thank you!

but i cant see it in thread tools only showing is show printable version and unsubscribe.