Using multiple functions to display data from another sheet

[rugbydud]

[TABLE="width: 156"]
<tbody>[TR]
[TD="class: xl65, width: 156"]

={IF(ISERROR(INDEX(Wednesday!$A$1:$C$250,SMALL(IF(Wednesday!$A$1:$A$250=$E$3,ROW(Wednesday!$A$1:$A$250)),ROW(Wednesday!1:1))-1,2)),"",INDEX(Wednesday!$A$1:$C$250,SMALL(IF(Wednesday!$A$1:$A$250=$E$3,ROW(Wednesday!$A$1:$A$250)),ROW(Wednesday!1:1))-1,2))}

[/TD]
[/TR]
</tbody>[/TABLE]

This is my code. $E$3 contains a 2 letter code. the formula uses this to display data in a worksheet. The data is in 3 columns, the 1st being the 2 letter code, and the other 2 are displayed. The Row function is searching through the list of data for the match to cell E3(which is the 2 letter code). My issue is that it currently only searches for a partial match. The 2 letter code is capitalized throughout the entire document, so matching exactly will not raise other issues. I have tried several iterations of the match and exact functions but can't seem to locate it in the correct place to get it to work.

 

[Special-K99]

Re: formula help-using multiple functions to display data from another sheet

"My issue is that it currently only searches for a partial match"

Where in the formula does it search for a partial match?
All comparisons in the formula are set to =, therefore that's a complete match not a partial match.

 

[rugbydud]

Re: formula help-using multiple functions to display data from another sheet

I don't understand it either. For example, when the cell value of E3 is AB, it is displaying all values for AB as well as A3, AZ, etc