|
|
#1
04-17-2019, 07:12 PM
|
|||
|
|||
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 
|
|
#2
04-17-2019, 11:13 PM
|
|||
|
|||
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)
|
|
|
|
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 |
Mac OS X 
Office 2016 for Mac
Linear Mode
