Using a named range in a vlookup

**AnthonyWB** · 04-05-2010, 05:12 PM

Hello everyone. I have the following excel formula:

Please Login or Register  to view this content.

I would like to use the named range "One_Bucket_Deal_IDs" in place of the cell references. How can I go about doing this. Thank you.

**teylyn** · 04-05-2010, 05:43 PM

ehm, just type it in?

=IF(ISERROR(VLOOKUP(E2,'L:\12_31_2009_105_Support_Summaries\[Rules.xlsm]Rules'!One_Bucket_Deal_IDs,1,FALSE)),"",E2&"_1")

**AnthonyWB** · 04-06-2010, 02:14 PM

Thanks but I seem to be having an error, following what you do - but not always for instance:

Please Login or Register  to view this content.

Returns #N/A

While,

Please Login or Register  to view this content.

Returns #NAME.

I have doubled checked to make sure that everything is spelled correctly. Any suggestions?

**teylyn** · 04-06-2010, 05:20 PM

#Name means a function or defined name is not found, i.e. you probably have a typo in your range name.

#N/A typically means that the lookup term cannot be found.

Try stepping through your formula with the Evaluate Formula tool to see where the problem occurs.

Or post a sample file.