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
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Mar 30, 2018

Armand,

 

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