Lookup help

tony_d

Board Regular
Joined
Sep 27, 2003
Messages
229
I have been given a work book with three worksheets open.
In the Master I need to return if in a lookup the values match but from two places.
I have currently got the below in place but it only returns from the first sheet Tes Master not Tes Tony
=IF(C201057="ZF",VLOOKUP(A201057,'TES Master'!A:D,2,FALSE),VLOOKUP(A201057,'TES Tony Master'!A:D,2,FALSE))

Is there a way?
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Hello Tony,

I think this will help you.

=IF(C11="ZF",IF(VLOOKUP(C201057,'TES MASTER'!A:D,2,FALSE)=VLOOKUP(A201057,'TES Tony Master'!A:D,2,FALSE),VLOOKUP(A201057,'TES Tony Master'!A:D,2,FALSE),"No Match"))

I used this formula to test it:

=IF(C11="ZF";IF(VLOOKUP(A11;A:A;1;FALSE)=VLOOKUP(D11;D:D;1;FALSE);VLOOKUP(A11;A:A;1;FALSE);"No Match"))

Hope it helps! :)
 
Upvote 0

Forum statistics

Threads
1,213,549
Messages
6,114,261
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top