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?

Sponsored Links
Old 01-25-01, 07:37 PM
Join Date: Mar 2000
Location: Lake Murray, SC USA
Posts: 1,461
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.


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Thread Tools
Search this Thread
Display Modes