| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula for multiple lookups
Yes thank you that is exactly what I needed.
"Dave Peterson" wrote: Debra Dalgleish shows how to use =index(match()) for this: http://www.contextures.com/xlFunctions03.html I think that's what you need/want. stephens176 wrote: I want to look at value in b58 (Jan)and the value in b8(Br 22)(and find the value at the intersection in worksheet PLAN. I have tried the lookup wizard and it appears it is going to work until the last option and it returns the error - the cell found by the wizard contains a formula returning an error. There are no formulas in Plan worksheet. -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula structure building ? check under the excel forum.... | Excel Discussion (Misc queries) | |||
| Excel Formula Issue | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
Threaded Mode
