Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
~Locating Cells to Begin Data Flow | Excel Worksheet Functions | |||
Ignoring blank cells while locating common text value | Excel Discussion (Misc queries) | |||
Locating | New Users to Excel | |||
Locating linked cells in Excel | Excel Discussion (Misc queries) | |||
Locating Trendline Equation Factors in Cells | Charts and Charting in Excel |