Hi

One way
=IF(OR(K22="",L22=""),"",INDEX($AF$7:$AN$14,MATCH( K22,$AE$7:$AE$13,0),MATCH(L22,$AF$6:$AN$6,0)))

Regards

Roger Govier


DHS64 wrote:
I have used this formula
=INDEX($AF$7:$AN$14,MATCH(K22,$AE$7:$AE$13,0),MATC H(L22,$AF$6:$AN$6,0))

Works great as long yoou have responses in k22 and l22 but if those are not
yet filled in i get a #N/A is there any way to return a blank unless there
is something in those refrenced cells.

Thannks