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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]bob
[/TD]
[TD]=A2&B2
[/TD]
[/TR]
[TR]
[TD]alex
[/TD]
[TD]=C2&D2
[/TD]
[/TR]
</tbody>[/TABLE]

thanks all

 

[gaz_chops]

Try something like

=A2&your vlookup formula here

 

[monsierexcel]

sorry i dont understand?