Index Formula Help

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
 
J

Jacob Skaria

Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula>}"

The below is just an example to show how to add more conditions.

=INDEX($C$2:$C$10,MATCH(1,($A$2:$A$10=D2)*($B$2:$B$10=D3),0))

the below are the two conditions
$A$2:$A$10=D2
$B$2:$B$10=D3


If this post helps click Yes
 
K

Ken

Yes ... I have used similar formula before ... However, I am having a problem
writing into my existing formula ... Can you provide guidance ... Thanks ...
Kha
 
K

Ken

OK ... I got it ... :)

{=INDEX('Short Desc'!$E$2:$E$10000,MATCH(1,($B3='Short
Desc'!$B$2:$B$10000)*(LEFT($C3,SEARCH(" ",$C3)-1)='Short
Desc'!$D$2:$D$10000),0))&" "&$E3}

Thanks ... Kha
 

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