Hi Steve

Maybe
=IF(Q19="","",HLOOKUP(I34,G92:O97,Q19+2)

Regards

Roger Govier


Steve K wrote:
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