Thread
:
LOOKUP Formula error but WHY???
View Single Post
04-17-2019, 11:13 PM
ArviLaanemets
Windows 8
Office 2016
Expert
Join Date: May 2017
Posts: 873
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)
ArviLaanemets
View Public Profile
Find all posts by ArviLaanemets