K
Ken
Excel2003 ... I have the following Formula which is working fine:
=INDEX('Short Desc'!$E$2:$E$10000,MATCH(LEFT($C3,SEARCH(" ",$C3)-1),'Short
Desc'!$D$2:$D$10000,0))&" "&E3
Issue is ... Formula is returning 1st occurance of the Match found in the
Index ... So I need to check a 2nd criteria ("WS1 Col B" vs "Short Desc Col
B").
How do I add this 2nd criteria? ... Thanks ... Kha
=INDEX('Short Desc'!$E$2:$E$10000,MATCH(LEFT($C3,SEARCH(" ",$C3)-1),'Short
Desc'!$D$2:$D$10000,0))&" "&E3
Issue is ... Formula is returning 1st occurance of the Match found in the
Index ... So I need to check a 2nd criteria ("WS1 Col B" vs "Short Desc Col
B").
How do I add this 2nd criteria? ... Thanks ... Kha