Forum Discussion

RobMoore67's avatar
RobMoore67
Copper Contributor
Jul 13, 2022
Solved

Excel Formula pulling text from another cell

cells  a1 = apple a2 = pear   =VLOOKUP($C8,'1. COM SERVICE'!$C$4:$J$25,6) I need to make '1. COM SERVICE' variable. VLOOKUP($C8,'a1'!$C$4:$J$25,6) so it would be VLOOKUP($C8,'apple'!$C$4:$J$25,...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 13, 2022

    RobMoore67 

    You may use INDIRECT, as variant

    =VLOOKUP($C8,INDIRECT( "'" & A1 & "'!$C$4:$J$25" ),6)
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 13, 2022

RobMoore67 

You may use INDIRECT, as variant

=VLOOKUP($C8,INDIRECT( "'" & A1 & "'!$C$4:$J$25" ),6)
RobMoore67's avatar
RobMoore67
Copper Contributor
Jul 13, 2022

SergeiBaklan 

Thank you so VERY much.

 It worked perfectly. 
Have. Wonderful day !