Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match function: error due to format?
Hi
I am having big trouble because the argument I use for the VALUE in the Match function seems to be in the wrong format. The value is not a number I hardcoded, but a number resulting from a formula combining "IF...RIGHT...CELL..." the result is = 9 Let's assume this result is in cell A1 if I now use MATCH(A1;7/8/9;0) the results is NA and my original 9 is showed (in the Match Arguments) like this: "9" instead of the pure number 9. Obviously if I hardcode 9 in A1, the match formula works properly becase I have now 9 instead of "9" in the VALUE argument how to solve it??? is there any formula to convert my result in A1? thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match function: error due to format?
hi,
in cell A1 =SI( ... DROITE ... CELLULE)*1 or =--SI( ... DROITE ... CELLULE) -- isabelle Le 2012-04-05 09:13, via sarpi a écrit : Hi I am having big trouble because the argument I use for the VALUE in the Match function seems to be in the wrong format. The value is not a number I hardcoded, but a number resulting from a formula combining "IF...RIGHT...CELL..." the result is = 9 Let's assume this result is in cell A1 if I now use MATCH(A1;7/8/9;0) the results is NA and my original 9 is showed (in the Match Arguments) like this: "9" instead of the pure number 9. Obviously if I hardcode 9 in A1, the match formula works properly becase I have now 9 instead of "9" in the VALUE argument how to solve it??? is there any formula to convert my result in A1? thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match function: error due to format?
hi,
in cell A1 =IF(...RIGHT...CELL...)*1 or =--IF(...RIGHT...CELL...) -- isabelle |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match function: error due to format?
Isabelle,
je t'adooooooooooooooooore!!!! merci beaucoup! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match function: error due to format?
c'est avec plaisir sarpi,
-- isabelle Le 2012-04-05 09:42, via sarpi a écrit : Isabelle, je t'adooooooooooooooooore!!!! merci beaucoup! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Format use with MATCH function | Excel Programming | |||
If Error condition with Match Function | Excel Programming | |||
Error Handling with a Match Function. | Excel Programming | |||
Match Function - no room for error | Excel Worksheet Functions | |||
Match function, N/A error, how do I get around it? | Excel Programming |