Need help with creating a formula
If cell a1 is between
0-14 then it equals 5
15-42 then it equals 4
43-63 then it equals 3
64-81 then it equals 2
84-100 then it equals 1
above 100 "ERROR"
Need help with creating a formula
If cell a1 is between
0-14 then it equals 5
15-42 then it equals 4
43-63 then it equals 3
64-81 then it equals 2
84-100 then it equals 1
above 100 "ERROR"
Try
=LOOKUP(A1,{0,15,43,64,84,101},{5,4,3,2,1,"Error"})
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
superstar thanks for all the help
i need this to look up the table and if it cant find a match then to return "CHECK"Please Login or Register to view this content.
any help peeps?
So your table has gaps ??
Please give an example
VBA Noob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks