| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Problem with Index and Match
Hi,
I am trying to get the following working using the lookup function. it works fine as it is shown however I have tried entering the lookup function referencing it from cell 'A5' but cant get it to work. Can anyone help by showing me the correct method. Thanks Mike =INDEX('12'!$B$2:$R$47,MATCH($D$1,'12'!$A$2:$A$47, 0),MATCH(1,IF('12'!$B$2:$R$2=$D$6,IF('12'!$B$4:$R$ 4=$A$3,1)),0)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Index Match?? | Excel Discussion (Misc queries) | |||
| advanced lookup/index-match problem | Excel Worksheet Functions | |||
| advanced lookup/index-match problem | Excel Discussion (Misc queries) | |||
| lookup/index/match - help! | Excel Discussion (Misc queries) | |||
| lookup (v,h,index,match) | Excel Worksheet Functions | |||
Threaded Mode
