Thread
:
Help with locating values in cells and caluculating
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett