| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with match? I don't know what formula use
Can anyone help?
I have two columns. In the column2 the data of mine is visible. The column1 contains data that I would like to obtain for specific countries in column2. Is there any simple formula/ solution that I can apply? Please help. Column1 Column2 Benelux Belgium Benelux Netherlands Nordic Denmark Nordic Finland Nordic Norway Nordic Sweden Russia Russia Exp UK United Kingdom France France Iberia Iberia Italy Italy |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help with match? I don't know what formula use
Sounds like you need a lookup table. Check out VLOOKUP in help.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "new_121" wrote in message ... Can anyone help? I have two columns. In the column2 the data of mine is visible. The column1 contains data that I would like to obtain for specific countries in column2. Is there any simple formula/ solution that I can apply? Please help. Column1 Column2 Benelux Belgium Benelux Netherlands Nordic Denmark Nordic Finland Nordic Norway Nordic Sweden Russia Russia Exp UK United Kingdom France France Iberia Iberia Italy Italy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
| Match formula | Excel Worksheet Functions | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
| Match Formula | Excel Worksheet Functions | |||
| Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions | |||
Hybrid Mode
