Microsoft Office Forums vlookup yeilds "weird" results...

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-05-2015, 06:36 AM
markjkubicki markjkubicki is offline vlookup yeilds "weird" results... Windows 7 32bit vlookup yeilds "weird" results... Office 2010 32bit
Novice
vlookup yeilds "weird" results...
 
Join Date: May 2015
Location: Brooklyn Hts, NY
Posts: 4
markjkubicki is on a distinguished road
Default 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),"")
which for a particular lookup used to return the text "FDB" (which is correct); now I get: 29490.5
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
Reply With Quote
  #2  
Old 05-06-2015, 02:01 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline vlookup yeilds "weird" results... Windows 7 64bit vlookup yeilds "weird" results... Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Could you please post a sample sheet? Thx
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #3  
Old 05-06-2015, 01:18 PM
markjkubicki markjkubicki is offline vlookup yeilds "weird" results... Windows 7 32bit vlookup yeilds "weird" results... Office 2010 32bit
Novice
vlookup yeilds "weird" results...
 
Join Date: May 2015
Location: Brooklyn Hts, NY
Posts: 4
markjkubicki is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 05-07-2015, 12:54 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline vlookup yeilds &quot;weird&quot; results... Windows 7 64bit vlookup yeilds &quot;weird&quot; results... Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

If you have headers try an INDEX/MATCH combination instead
__________________
Please note I am not active on this forum anymore
Reply With Quote
Reply

Thread Tools
Display Modes


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
vlookup yeilds &quot;weird&quot; results... 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
vlookup yeilds &quot;weird&quot; results... 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


All times are GMT -7. The time now is 03:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft