how to turn a text string into a formule

hi have concancate cells in sheet create formula in cell (eg. d7).

if copy cell d7 , paste hard text and double click on it, works fine.

=vlookup(f:f;a:b;2;0)

my challenge use cell d7 reference in large sheet.

is there solution reference working formula instead of appearance

=vlookup(f:f;a:b;2;0)

thanks in advance

lloydm

hi lloydm,

based on description, understanding want formula works when copying formula large sheet.

if so, explain not work, have change sheet , parameter (f:f, a:b) display data on new sheet.

you need change parameter.

about how use vlookup formula, can refer following article:

thanks,

qing

Office / Excel / Windows other / Office 365 for business

Cororate