Excel vlookup issue


Ryk

Joined
Jul 18, 2008
Messages
6
Reaction score
0
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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top