EXCEL FUNCTION

I have been thinking of combining if and vlookup functions to help me find and look for values as follows:

=IF(VLOOKUP(B:B,I:K,2,FALSE)=C:C,VLOOKUP(B:B,I:K,3,FALSE),””)

I notice that the above function only considers the fisrt match and fails to go further down the clumn to compare the events.

Help me get the correct function which will help me find the correct results.

 

By: James Mwanzia

Leave a Reply

Your email address will not be published. Required fields are marked *