| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return matching value
Workbook1
Sheet1 A 1 car 2 boat 3 plane 4 train 5 motorbike Workbook2 Sheet1 A B 1 moterbike formula returns motorbike 2 car formula returns car 3 lorry formula returns no match found The formula looks in workbook1 and returns the same value as that displayed in colA. If no match is found then display message. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look up two values in different columns and return matching value | Excel Discussion (Misc queries) | |||
| matching two worksheets and return to different value | Excel Worksheet Functions | |||
| Return Matching Data Help Needed | Excel Discussion (Misc queries) | |||
| Return all matching values | Excel Worksheet Functions | |||
| Looking and matching vaules to return another vaule | Excel Discussion (Misc queries) | |||
Threaded Mode
