Need a different way of looking.

[GAJITCS]

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD][/TD]
[TD]X[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]ALPHA[/TD]
[TD]BRAVO[/TD]
[TD]CHARLIE[/TD]
[TD]DELTA[/TD]
[TD]ECHO[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4.23[/TD]
[TD]4.20[/TD]
[TD]5.45[/TD]
[TD]6.00[/TD]
[TD]4.23[/TD]
[TD]4.23[/TD]
[TD]ECHO[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]4.88[/TD]
[TD]4.92[/TD]
[TD]4.92[/TD]
[TD]0.00[/TD]
[TD]4.99[/TD]
[TD]4.92[/TD]
[TD]CHARLIE[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]5.58[/TD]
[TD]4.88[/TD]
[TD]6.23[/TD]
[TD]6.23[/TD]
[TD]5.58[/TD]
[TD]5.58[/TD]
[TD]ECHO[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]4.72[/TD]
[TD]4.72[/TD]
[TD]4.72[/TD]
[TD]4.40[/TD]
[TD]4.88[/TD]
[TD]4.72[/TD]
[TD]CHARLIE[/TD]
[/TR]
</tbody>[/TABLE]
This bit works......G3 is the smallest value found in A3:F3 but excludes from the search results, any column where an X exists in row 1. It also excludes any values of zero.

The problem I have is populating H3. H3 needs to find the value from G3 in A3:F3 and return the value from row 2 from the column it was found in, keeping in mind that some of the columns were excluded from the original search that populated column G.

Many thanks for any help that can be given.

 

[admiral100]

Hi.

Try this : H3 =IFERROR(INDEX($A$2:$E$2,MATCH(1,($A$1:$E$1<>"X")*(A3:E3=F3),0)),"")

 

[GAJITCS]

Hi.

Try this : H3 =IFERROR(INDEX($A$2:$E$2,MATCH(1,($A$1:$E$1<>"X")*(A3:E3=F3),0)),"")

Spot on sir. Many Thanks

 

[admiral100]

You are welcome , thank you for your feedback.