| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching Three columns and returning a value
I have a Spreadsheet with two sheets.
Sheet 1 has the following data in columns Forname Surname Birth Place Nationality Alan Jones Liverpool Allan Jones Cardiff David Ellis Manchester David Ellis Leeds Clive Newman London Sarah Roberts Cardiff Sheet 2 has the following Surname Forename Birthplace Nationality Forename Birthplace Natioanlity Jones Alan Liverpool English Allan Cardiff Welsh Ellis David Manchester English David Leeds English etc How can I insert in sheet 1 the nationality where all three varialble must match i.e. Alan Jones Liverpool = Jones Alan Liverpool and returns the text English in Sheet 1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching & Returning values | Excel Discussion (Misc queries) | |||
| only returning 1st matching entry in table, need to find next matc | Excel Worksheet Functions | |||
| Matching numbers in an Array and returning values for matched numb | Excel Discussion (Misc queries) | |||
| returning all matching values in column A that have the same value for columnB | Excel Worksheet Functions | |||
| Returning a Value by Matching Two Columns of Data | Excel Worksheet Functions | |||
Threaded Mode
