Adding Associated Column to Index/Count IF

Hello! I was wondering if anyone can help me with this - I think it is simple and I am just blind in the brain this morning.

(Details changed for simplicity)

I have six columns, A:F

Column A is a numerical value
Column B is a text value
Column C is a text value

e.g. A|B|C

2|Cups|Flour

1|Tablespoon|Sugar

3|Cups|Flour

Column D uses SUMIF checking Column C for the value in Column F, and summing column A in the case of a match
=SUMIF($C$2:$C$546,F2,$A$2:$A546 )

Column E ????????

Column F is an index used to consolidate the data in Column C
=INDEX($C$2:$C$546,MATCH(0,INDEX(COUNTIF($F$1:F1,$C$2:$C$546),0,0),0))

Which outputs:

5| |Flour

I am trying to figure out a way that the above example outputs:

5|Cups|Flour

Values should be consistent to the user, but not ever user may choose to use Cups for Flour, so I can't use a black and white IF statement - I Think I need something that checks Column C for the value in a cell in Column F2, F3..., and, outputs Column B from the any of the* found match's row to Column E2, E3...

*again, this shouldn't matter as it should be consistent within the sheet.

Seamless/Easy compatibility is required, and I am trying to avoid macros - this is the last bullet I have to dodge I think for the latter!

I could be going about it all wrong - any help would be much appreciated!

bebo, Tony - Thank you so much!

"Look at Column D, dummy!" would have also been acceptable - I was definitely in that spot where I was blind to the solution, it would have taken me forever to get out of it without you two - appreciate it!