View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
JayPee JayPee is offline
external usenet poster
 
Posts: 12
Default formula not working

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?