| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
match then return a value
Hello there,
I am looking for some help. I have two spreadsheets and I need to match the policy number from worksheet 1 and 2 and if they are a match then add the renewal date in speadsheet #1. Any help is appreciated ie. Worksheet 1 A B C NAME Policy # Renewal date John 32 ? Chris 16 ? Brian 15 ? Worksheet 2 A B Policy # Renewal Date 32 12/12/2009 24 15/01/2001 15 15/03/2006 16 18/02/2003 18 24/09/2006 17 17/06/2005 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200907/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to return next match of table, only finding first match...HEL | Excel Worksheet Functions | |||
| MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
| return N/A when no first match but do nothing if no second match | Excel Worksheet Functions | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| MATCH 3 COLUMS RETURN 4TH | Excel Discussion (Misc queries) | |||
Threaded Mode
