Forum Discussion

Armand Koekemoer's avatar
Armand Koekemoer
Copper Contributor
Mar 30, 2018

=VLOOKUP(A3;INDIRECT(""&A5&&"!$A$3:$C$20");2;FALSE)

Ref Error

Hi I am trying to combine figure from three different worksheets, and I keep getting an Ref Error.

 

Anyone please assist.

excel
  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    Mar 30, 2018

    What do you have in cell A5?  If it isn't a valid worksheet name you'll get a #Ref Error.  

     

    If the issue persists could you possibly attach a sample mockup with the scenario you mention.  That will make it easier to troubleshoot the issue.

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Mar 31, 2018

    Armand,

     

    your formula references to cell A5 and that would be only one worksheet name and not three.

     

Resources