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
=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
