excel - Index Match query with if statement in the Match -


i'm trying index match statement between 2 different worksheets. need add condition on sheet match.
effectively, have list of vessel names in sheet 1 (col c), , in sheet two, vessel name (col c)the contract end dates (col q) , contract status (col al)
in sheet 1 need return contract end date. however, there potential duplicates in sheet 2 want return date if contract status on row not 'completed'
it's condition seems not work, appreciated
thanks!

=if('infield vessel contracts'!al:al<>"complete",index('infield vessel contracts'!q:q,match(c162,'infield vessel contracts'!c:c,0)),"no contract")     

you might try:

=--('infield vessel contracts'!al:al="completed")*index('infield vessel contracts'!q:q,match(c162,'infield vessel contracts'!c:c,0)) 

Comments

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -