| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If function to match cols and return value of another col
Hi,
Is it possible to use this function below, to then return the value of the matching cells in Col I. For example if there is a direct match for A2 in Col E, then in either this cell of another return the value in col I relating to Col E? IF(ISNA(MATCH(A2,E:E,0)),"no match","match") |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If function to match cols and return value of another col
This is untested, but try this:
=IF(ISNA(MATCH(A2,E:E,0)),"no match",INDIRECT("I" & MATCH(A2,E:E,0))) HTH, Paul -- "Haz" wrote in message ... Hi, Is it possible to use this function below, to then return the value of the matching cells in Col I. For example if there is a direct match for A2 in Col E, then in either this cell of another return the value in col I relating to Col E? IF(ISNA(MATCH(A2,E:E,0)),"no match","match") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I match 2 cols on two books and get price info for all matc | Excel Worksheet Functions | |||
| Using MATCH function does not return correct answer | Excel Worksheet Functions | |||
| Index? Match? Function to sort and return value fr diff column in | Excel Worksheet Functions | |||
| Cond Format:re color 2 cols, skip 2 cols | Excel Worksheet Functions | |||
| Error Return Value from and INDEX(A:2,MATCH()) function | Excel Worksheet Functions | |||
Linear Mode
