<or am i getting this error for another reason?

How could we possibly know without seeing your formula?

But look in Excel HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"mwam423" wrote in message ...
| greetings everybody, am hoping to confirm something. i was using VLOOKUP, to
| determine a range name for the range to search, inside a VLOOKUP. kept
| getting #VALUE! and this is because VLOOKUP doesn't accept a formula as the
| range to do the lookup on, is that correct? or am i getting this error for
| another reason?