View Single Post
  #1   Report Post  
Steve K
 
Posts: n/a
Default Another #N/A Result question...Sorry

I've read and tried every conceivable posibbilty I could think of, with no
succes.

The formula below results in #N/A if Q19 = nothing....how can I get a blank
cell result?

=IF(Q19=1,HLOOKUP(I34,G92:O97,3),IF(Q19=2,HLOOKUP( I34,G92:O97,4),IF(Q19=3,HLOOKUP(I34,G92:O97,5),IF( Q19=4,HLOOKUP(I34,G92:O97,6),""))))

Steve