Problem with Excel

Old 01-25-01, 05:05 PM
Visiting Guest
Posts: n/a

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?

Old 01-25-01, 07:37 PM
Join Date: Mar 2000
Location: Lake Murray, SC USA
Posts: 1,413
Upvotes: 0
Received 1 Upvote on 1 Post
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.


Thread Tools
Search this Thread
Ask a Question
Question Title:
Your question will be posted in: