vlookup based on if function

[kypok999]

hi Guys,

I have data range I need to lookup for:

I attached the file so I am looking for unique id as in "Combined Sheet" column A2 I need to produce result in column x,y,z but need to be based on x1 y1 z1 values so its looking for A2 in sheet "Top3FAVData" if x1 =1 for x column and if y1=1 and z1=1 for y ,z columns so bascially lookup should look for A2+$x1 from "Combined sheet" in "Top3FAVData" it would look into A2 column +z2 and show result from AE column

I copy pasted result in x1,y2,z2 how it should look like with formula

Thank you in advance sorry if I wrote this complicated..

https://docs.google.com/spreadsheets/d/110-z6_x0U14iHWS5kAWjSg1S4-USAZ8vXE-AIxrLaXc/edit?usp=sharing

 

[kypok999]

Thank you Erik all working!!!

 

[inactiveuserps07]

Glad to hear it, Alex. Thanks for reporting back.