query on vlookup with cell formula not cell value

[sarvajit]

hi...


i want cell formula instead of cell value using vlookup so can anybody help to solve this query?

 

[Debraj]

Hi Sarvajit,


Welcome to the forum..


Can you please elaborate a little bit more..


Why do you need the FORMULA not the VALUE..


Excel has own capability to adjust his own cell reference according to position.. IF you sum two fields.. and the copy the same to any other are.. It will may be now referencing to any other cell.. SO.. you are trying to destroy.. excels special feature..


and if you look-up the formula from a virtual table by some searchable VALUE.. will the same formula, in found strings.. 3rd or 7th column.. exact same formula you need to you need the replica of that formula.. in new loaction.. by changing the references..


May be your elaboration, can help MICROSOFT also to give the same feature by default..


Regards,

Deb

 

[lhkittle]

Maybe this, I am vague on understanding the question.

[pre]

A	AA	D	DD	444	AA	111
B	BB				BB	222
C	CC				CC	333
D	DD				DD	444

[/pre]

Where the data is in columns A, B, C, D, E, F, G.

Where cell D1 returning DD is =VLOOKUP(C1,A1:B4,2,0)

Where cell E1 returning 444 is =VLOOKUP(D1,F1:G4,2,0)


Regards,

Howard