Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel function
Hi all,
my problem is as follow. Column A alfa beta gamma theta epsilon ro Column B 0.00000% 6.57481% 153.23505% -2.51575% 0.00000% 153.23505% Column C (in other words, the same value of Column B, but sorted) 153.23505% 153.23505% 6.57481% 0.00000% 0.00000% 0.00000% Column D. I'd want to get the values (in column A) for every values in Column C, so I used: =INDEX($A$3:B$337,MATCH(C3,$B$3:B$337,0),1) but the result is not the one right. I get: gamma gamma beta alfa alfa alfa For example: the value 0.00000%, I always get "alfa" : but in the first case "alfa" is right, in the second case I'd like to get "epsilon". The other case: the value 153.23505%. In the first case, I get "gamma" and it's right, but in the second case I'd like to get "ro", instead of "gamma" .. What should I do to get, for every value of Column C, the right value of Column A ? Any suggestion very appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel function
Be sure that your data starts in row 3, or change your formula to reflect the
actual row that the data range begins in. =INDEX($A$3:$B$337,MATCH(C3,$B$3:B$337,0),1) "asburypark98" wrote: Hi all, my problem is as follow. Column A alfa beta gamma theta epsilon ro Column B 0.00000% 6.57481% 153.23505% -2.51575% 0.00000% 153.23505% Column C (in other words, the same value of Column B, but sorted) 153.23505% 153.23505% 6.57481% 0.00000% 0.00000% 0.00000% Column D. I'd want to get the values (in column A) for every values in Column C, so I used: =INDEX($A$3:B$337,MATCH(C3,$B$3:B$337,0),1) but the result is not the one right. I get: gamma gamma beta alfa alfa alfa For example: the value 0.00000%, I always get "alfa" : but in the first case "alfa" is right, in the second case I'd like to get "epsilon". The other case: the value 153.23505%. In the first case, I get "gamma" and it's right, but in the second case I'd like to get "ro", instead of "gamma" .. What should I do to get, for every value of Column C, the right value of Column A ? Any suggestion very appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel function
On 21 Giu, 16:13, JLGWhiz wrote:
Be sure that your data starts in row 3, or change your formula to reflect the actual row that the data range begins in. =INDEX($A$3:$B$337,MATCH(C3,$B$3:B$337,0),1) the formula is right. my data start in row 3 end ends in row 337.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
Adding a custom function to the default excel function list | Excel Programming | |||
When I Import an Access Table With an Excel Function in a Cell it Displays as Text not as a Function in Excel | Excel Programming |