Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding an error value, using INDEX/MATCH
Hi,
I am using the INDEX/MATCH combination to look for data in some source files. In case a value is missing the formula will return an error value": #N/A. I know it is possible to hide the error values using =IF(ISERROR)€¦.etc. I just dont get it right in combination with the INDEX/MATCH function I am currently using. I am using: =INDEX(array;row_num;column_num) An example: =INDEX('D:\Marieke Test\TEST BESTANDEN\[TEST PROTECTION.xls]Sheet1'!$A$1:$AD$418;MATCH(E3;'D:\Marieke Test\TEST BESTANDEN\[TEST PROTECTION.xls]Sheet1'!$R$1:$R$418;0);MATCH("merkstam*";'D:\Marie ke Test\TEST BESTANDEN\[TEST PROTECTION.xls]Sheet1'!$A$1:$AD$1;0)) Can somebody tell me how to incorporate the IF(ISERROR)€¦so that if the formula would return an error value, instead it will show a blank in that cell? Thanks a lot! Marieke |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDEX/MATCH #REF! error | Excel Discussion (Misc queries) | |||
index/match error | Excel Worksheet Functions | |||
INDEX MATCH #N/A Error | Excel Worksheet Functions | |||
VALUE error with index(row.. match(true.. row.. | Excel Discussion (Misc queries) | |||
#num Error index, match | Excel Worksheet Functions |