| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match based on calculated value
I am trying to use the INDEX and MATCH functions based on a calculated value.
=INDEX(Scoring!G11:H50,MATCH(C3,Scoring!H11:H50,0) ,1) Cell C3 is a calculated value:=C2*C6-E6 The result in the cell is #N/A.. is there a way to use a calculated value in a MATCH function -- Tekhnikos |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to create a calculated item based on a calculated field | Excel Discussion (Misc queries) | |||
| The amount calculated based on two entry criteria (somproduct?) | Excel Discussion (Misc queries) | |||
| Calculated Field in Pivot Table Based on Two Counted Fields | Excel Discussion (Misc queries) | |||
| Are financial functions calculated based on compound interest? | Excel Worksheet Functions | |||
| Pivot table help:calculated field based on previous consecutive va | Excel Discussion (Misc queries) | |||
Threaded Mode
