Problem with Excel

Any of you computer buffs familiar with Excel spreadsheet functions are welcome to jump in on this one - here's the situation.

I am using pieces of operator (user) input to determine which named range the VLOOKUP function will utilize in order to produce an answer. The input is concatenated and formatted as text in one cell. When this cell is referenced in the VLOOKUP function, it returns a value of #N/A, and the function fails. If I type the range name into the function (instead of referencing the cell containing the range name), it works.

What's happening?

George

 

I'm assuming the range name includes several cells, one of which is the one you had tried to reference as a single cell.

Does this help?

If lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the #N/A error value.