Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-17-2019, 07:12 PM
Haga Haga is offline Mac OS X Office 2016 for Mac
Novice
 
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 Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 436
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
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 10:08 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft