Take a look at INDIRECT in help. I think it will do what you want.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Chussong" wrote in message
...
I want to create a formula that performs a V-lookup from a range, then
based
on that look-up, has an IF function to give me the correct data. Simply
put,
is it possible to nest two different functions within one cell?
Also, how do I create formulas that get information from one spreadsheet
to
another without being row specific? I want to be able to pull the
information
from rows 1-200, into rows 1-X(based on a formula searching for specific
values within the spreadsheet.)