naming a cell in a vlookup formula

[cocowenman]

hi all.

I have a workbook with the formula =VLOOKUP("PRESTON",'CALL SUMMARY'!A:B,2,FALSE) which works fine (e.g if preston is in column A it will display the figure in column B).

the adaptation I want to make to this formula is instead of naming "preston" I want it to look for whatever is written in a cell D1. (e.g if preston is in cell D1 it will look for Preston in column A and display the figure in column B, allowing me to change the name in D1 and it will look up and change the figure.

I hope that makes sense, appreciate any help.

thanks
m

[alansidman]

=vlookup(d1,'call summary'!a:b,2,false)