| 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 | |||
Linear Mode
