Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I'm not sure why this isn't working ... please help.
A B 0.999 1 0.799 2 0.699 3 0.599 4 0.499 5 0.399 6 0.299 7 0.199 8 0.99 9 I just need to lookup a value in ,say, C1 and compare to colA and return a value in colB. Using: =IF(M41=0,10,IF(M411,0,VLOOKUP(M41,$C$60:$D$68,2) )) yields #N/A for any value not 0 or 1. What gives? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Not working | Excel Discussion (Misc queries) | |||
Formula only working sometimes | Excel Discussion (Misc queries) | |||
Formula Sometimes Working Sometimes Not | Excel Discussion (Misc queries) | |||
Formula not working | Excel Discussion (Misc queries) | |||
formula not working | Excel Discussion (Misc queries) |