| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index/Match Amateur Question
So if I have cities filling column E (to E1236) and their respective
countries in column H (to H1236) How do I write the function so that in a new record the country value automatically matches the city I input? I've tried this, but no dice: =INDEX(H:H,MATCH(H10,E:E,0)) Thank you for any help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/Match Question | Excel Discussion (Misc queries) | |||
| Index/match question. | Excel Discussion (Misc queries) | |||
| Index/match question. | Excel Worksheet Functions | |||
| Index/Match question Need help! | Excel Worksheet Functions | |||
| Match + Index(?) Question | Excel Discussion (Misc queries) | |||
Threaded Mode
