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

    Files

    • vlookup.xlsx

      (10.06 kB, downloaded 35 times, last: )
  • 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