Lookup Formula

[rizmomin]

Hello:

Please refer to attached file.
i have data as shown in column A.
I will have Items in cell E6:E8 as shown.
I need formula in cell F6:F8 to give numbers as shown.

Let me know if you have any questions.
Thanks.

R

[Phuocam]

Try:

=LOOKUP(10^20,--LEFT(INDEX($A$14:$A$16,MATCH("*"&E6,$A$14:$A$16,0)),ROW(INDIRECT("1:20"))))

[Glenn Kennedy]

=LOOKUP(10^10,--LEFT(INDEX($A$14:$A$16,MATCH("*"&E6,$A$14:$A$16,0)),ROW($1:$10)))

But kill the space in Drive Thru in E8...

[AlKey]

Try this
Enter F6 and copy down

Please Login or Register  to view this content.

[rizmomin]

Hello:

Thanks to all.
I am sure i will use of the above.
Riz