Microsoft Office Forums LOOKUP Formula error but WHY???

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-17-2019, 07:12 PM
Haga Haga is offline LOOKUP Formula error but WHY??? Mac OS X LOOKUP Formula error but WHY??? Office 2016 for Mac
Novice
LOOKUP Formula error but WHY???
 
Join Date: Apr 2019
Posts: 1
Haga is on a distinguished road
Angry LOOKUP Formula error but WHY???

Hi,

I know and I used a lot of times the LOOKUP formula.
But I don't understand why got an N/A error message now.
And if you see the example table you can see something wrong.

Can anyone explain to me what's wrong??



Thank you in advance!

Gabor
Attached Images
File Type: png Screen Shot 2019-04-17 at 18.49.42.png (147.5 KB, 11 views)
Reply With Quote
  #2  
Old 04-17-2019, 11:13 PM
ArviLaanemets ArviLaanemets is offline LOOKUP Formula error but WHY??? Windows 8 LOOKUP Formula error but WHY??? Office 2016
Expert
 
Join Date: May 2017
Posts: 463
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
Default

VLOOKUP here needs numbers in E$4:E$10 to be sorted in ascending order. Currently, it not only does return #N/A for 2 top rows, it also returns false literas for 5 and 6.

Use VLOOKUP instead
Code:
=VLOOKUP(C5;E$5:F$11;2;0)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
N/A Value in Lookup Formula NickFazer Excel 2 04-02-2019 04:22 AM
How to update lastname with the help of V-Lookup formula? Mangesh1212 Excel 6 12-05-2018 02:15 AM
LOOKUP Formula error but WHY??? Filter or Lookup Formula to Organize Keywords MKTGCLOUD Excel 8 11-28-2018 07:35 PM
Need help with lookup formula tristanlau Excel 1 08-14-2017 07:16 AM
Formula help please (lookup across multiple sheets) froggybsb03 Excel 2 03-16-2017 02:16 AM


All times are GMT -7. The time now is 04:51 AM.


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