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


  • 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


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!