Help with locating values in cells and caluculating
 

Please I have this

A1 box
A2 book
A28 Jug


A200 box = b200* (Find Box in A1:A150) i.e b10*A1
A201 Jug = b201* (Find Jug in A1:A150) i.e b10*A28

I want to calculate cell based on findings as explained above. All help
totally appreciated.

Thanks

Help with locating values in cells and caluculating
 

Have a look in the help index for MATCH to find the row and INDEX to use the
match
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Yossy" wrote in message
...
Please I have this

A1 box
A2 book
A28 Jug


A200 box = b200* (Find Box in A1:A150) i.e b10*A1
A201 Jug = b201* (Find Jug in A1:A150) i.e b10*A28

I want to calculate cell based on findings as explained above. All help
totally appreciated.

Thanks