Vlookup - - can it pull in a formula?

[SeanCondon]

hi all,
I'm trying to confirm whether I can use a vlookup formula on one tab, to bring in an active formula from another tab?

example:
tab 1- cell a1 has a key, cell b1 and c1 have data
tab 2- column A has a list of keys and column B has a formula that is unique to each key

I'd like to be in tab 1, and use a vlookup based upon the key in a1. it should bring in the formula and then allow me (in a secondary cell maybe?) to use that formula on the data that resides in same tab 1

any insight is appreciated. thanks,

Sean

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=578517

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).