Multiple vlookup

Hi folks

I'm struggling with a multiple vlookup and was hoping for some help/advice please.

I need the vlookup to look at a reference number in column B on sheet 1, find that reference number on sheet 2, then look up a word on sheet one in column C and if that word is in column Y in the corresponding row on sheet 2 return the value (text) that is in column X on sheet 2. If there is nothing in Column x then do nothing.

I got as far as:

=IFERROR(VLOOKUP(B2,'Control sheet '!B:B,2,0),(IFERROR(VLOOKUP(B2,'Control sheet '!Y:Y,3,0),IFERROR(VLOOKUP(B2, 'Control sheet '!X:X,0)))

But the last bit is wrong and I can't figure out how to just get it to return the value in column Y

Any advice please?

Kind regards

DezB

Hi bosco_yip

My apologies for taking so long to thank you for your help, I should have done it earlier..

I'll try harder in future...

Kind regards

DezB