Hello all
I'm trying to lookup values with multiple criteria and from results i need to exclude all values if number in column E (sheet7) = 90
as the result I should get values with blanks or zeros or N/A in case there is number 90 in cells in column E
I applied below formula however excel does not exclude those values (to exclude values I have used <> )
=INDEX(Table_dg_dc01_progress_ProgressDotNet_Gear_PurchaseOrderDetail[PODetNum], MATCH(1, ([@WONo]=Table_dg_dc01_progress_ProgressDotNet_Gear_PurchaseOrderDetail[PODetWordNo])*([@WORoutOpNo]=Table_dg_dc01_progress_ProgressDotNet_Gear_PurchaseOrderDetail[PODetSubConOpNo])*(Table_dg_dc01_progress_ProgressDotNet_Gear_PurchaseOrderDetail[PODetStatus]<>"90"), 0))
Can you please advise
thanks
Bookmarks