| Home |
| Search |
| Today's Posts |
|
#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") |
| 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 | |||
Threaded Mode
