Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Index function
I am trying to use the following index function. Seems to me like it is ok,
but when I type this into the cell I do not get a result, I simply see the formula (I do not have the view formula option selected). I am using Excel 2007. =INDEX(Results!$D$2:$D$21,MATCH($B3,Results!$A$2:$ A$21,0)) I have tried to make this an array formula, but that does not work. When I select Ctrl+Select+Enter nothing happens. What I am trying to do is find a match to cell B3 in one worksheet to an entry in column A from worksheet "Results" spreadsheet. I then want the corresponding entry in column D from the "Results" spreadsheet to be my answer. I should also note that the entries in column D are text and not number or formula entries. TIA |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Index function
If you see the formula in a cell rather than the value, the problem usually
is that the cell was formatted to Text before the formula was entered. 1. clear the cell 2. format as General 3. re-enter the formula -- Gary''s Student - gsnu2007h "Steve M" wrote: I am trying to use the following index function. Seems to me like it is ok, but when I type this into the cell I do not get a result, I simply see the formula (I do not have the view formula option selected). I am using Excel 2007. =INDEX(Results!$D$2:$D$21,MATCH($B3,Results!$A$2:$ A$21,0)) I have tried to make this an array formula, but that does not work. When I select Ctrl+Select+Enter nothing happens. What I am trying to do is find a match to cell B3 in one worksheet to an entry in column A from worksheet "Results" spreadsheet. I then want the corresponding entry in column D from the "Results" spreadsheet to be my answer. I should also note that the entries in column D are text and not number or formula entries. TIA |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Index function
Steve,
Sounds like the cell was preformatted, as text. Format as General, then re-enter the formula. HTH, Bernie MS Excel MVP "Steve M" wrote in message ... I am trying to use the following index function. Seems to me like it is ok, but when I type this into the cell I do not get a result, I simply see the formula (I do not have the view formula option selected). I am using Excel 2007. =INDEX(Results!$D$2:$D$21,MATCH($B3,Results!$A$2:$ A$21,0)) I have tried to make this an array formula, but that does not work. When I select Ctrl+Select+Enter nothing happens. What I am trying to do is find a match to cell B3 in one worksheet to an entry in column A from worksheet "Results" spreadsheet. I then want the corresponding entry in column D from the "Results" spreadsheet to be my answer. I should also note that the entries in column D are text and not number or formula entries. TIA |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Index function
You shouldn't even need to clear the cell. Just format as General, put the
formula into edit mode (by clicking in it or by F2), and then accept the formula again. -- David Biddulph "Gary''s Student" wrote in message ... If you see the formula in a cell rather than the value, the problem usually is that the cell was formatted to Text before the formula was entered. 1. clear the cell 2. format as General 3. re-enter the formula -- Gary''s Student - gsnu2007h "Steve M" wrote: I am trying to use the following index function. Seems to me like it is ok, but when I type this into the cell I do not get a result, I simply see the formula (I do not have the view formula option selected). I am using Excel 2007. =INDEX(Results!$D$2:$D$21,MATCH($B3,Results!$A$2:$ A$21,0)) I have tried to make this an array formula, but that does not work. When I select Ctrl+Select+Enter nothing happens. What I am trying to do is find a match to cell B3 in one worksheet to an entry in column A from worksheet "Results" spreadsheet. I then want the corresponding entry in column D from the "Results" spreadsheet to be my answer. I should also note that the entries in column D are text and not number or formula entries. TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index Problem | Excel Worksheet Functions | |||
=Index Problem | Excel Discussion (Misc queries) | |||
Index function - problem copying to other cells | Excel Worksheet Functions | |||
INDEX PROBLEM...I THINK | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |