Microsoft Office Forums

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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:54 AM.


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