Thread: LOOKUP Formula error but WHY???
View Single Post
 
Old 04-17-2019, 11:13 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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