You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"brownti via OfficeKB.com" <u31540@uwe wrote in message
news:9edca45573480@uwe...
Both work perfect! Thank you very much

Ashish Mathur wrote:
Hi,

Try this

=INDEX(Sheet1!$F$3:$F$6,SUMPRODUCT((Sheet1!$C$3: $E$6=Sheet2!B4)*(ROW(Sheet1!$C$3:$C$6)-ROW(Sheet1!C$2))),1)
and copy down

Sheet1!$C$3:$E$6 is the 4 column shown in your question below
Sheet2!B4 contains 100 on another worksheet

I have a table that looks like the following:

[quoted text clipped - 28 lines]

Thanks for any input!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200911/1