View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yossy Yossy is offline
external usenet poster
 
Posts: 127
Default 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