Excel vlookup issue

[Ryk]

I am trying to make a vlookup and if statement combined, to me this looks right....

=IF(ISNA(VLOOKUP(Sheet1!$C$4,"no",techs,2)),"",VLOOKUP(A21,techsOT,2))

techs and techsOT are ranges, Sheet1 C4 is a cell I pick yes or no from to switch ranges and A21 is a storage cell that sets the rate for sheet one to multiply times hrs worked? Any ideas on this?

Ryk

 

[guest_9323wk]

Hi,

Please look at this

Regards

Wiz