#1
|
|||
|
|||
vlookup yeilds "weird" results...
every so often... and now is one of those times...
a previously valid formula, which yielded totally valid results, is currently returning: gobbly-gook an example is: Code:
=IFERROR(VLOOKUP(C13,Load_Type,15,FALSE),"") or in another cell, instead of the anticipated result "INC", I get 3300.468468 2 notes: - it's never just a random formula; when it happens, it's ALL of the formulas on the sheet - the gobbly-gook answer is always consistent -ex: wherever I am looking up the same value, I always get the same result perplexed... (but with many thanks in advance), mark |
#2
|
||||
|
||||
Could you please post a sample sheet? Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
AURGH
the lookup references a named range, and the 15th column in that range; howeveer, if additional columns have been added within the range <15> is no longer valid (it will still provide a result from the 15th column, but that may no longer be the correct one)... not sure what happens when columns are hidden / unhidden; but somewhere between this and the other lies the problem ! thanks all |
#4
|
||||
|
||||
If you have headers try an INDEX/MATCH combination instead
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N | mikey386 | Excel | 2 | 12-11-2014 01:14 PM |
Weird "new/blank document" format in Word 2007 | bjones | Word | 2 | 06-07-2014 06:45 AM |
Weird issue with changing "weight" of a boarder | grizzy | PowerPoint | 6 | 03-12-2014 10:15 AM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
Instant Search's "Display search results as I type when possible" with Exchange | lwc | Outlook | 0 | 06-01-2011 01:56 AM |