Lookup Row, Return Column Header

**matt4003** · 06-21-2010, 04:20 PM

Hello Everyone,

I have looked for examples, however unsuccessful, for my apparently simple issue.

All I am trying to do is create a lookup for values in Row 3 and return the Row 2 same column value.

Attached is what I am trying to do.

Thanks,
Matt

**NBVC** · 06-21-2010, 04:26 PM

Try:

=INDEX($D$2:$I$2,MATCH(C3,$D3:$I3,0))

If you want dynamic, change $I$2 and I$3 to $IV$2 and $IV3, respectively to expand the whole row...

This will capture first bidder it comes across if more than one have same highest bid.

**matt4003** · 06-21-2010, 10:54 PM

Hello NBVC,

Thanks for the reply. It works well.

From a dynamic perspective your suggestion works as long as the users don't put "usless" information out to the right side of the data, like subtotals, etc. Is there any way to use a more structured dynamic approach? Maybe some kind of offset function??

Thanks,
Matt