Anyway to generate formula based on a vlookup or index/match?

[monsierexcel]

Hello all, this is a little complex.

I would like to produce a vlookup but the value it produces is another formula.

for example,
I want to vlookup (or index match) bob - i want the value to then produce the formula of "=A2&B2" in another sheet, not the value, is this possible?

the formula structure changes depending on what is referenced.

bob	=A2&B2
alex	=C2&D2

<tbody>
</tbody>

thanks all

 

[gaz_chops]

Try something like

=A2&your vlookup formula here

 

[monsierexcel]

sorry i dont understand?