| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match values in two different columns
dear forum, help please. i have 2 columns in sheet 1: col A is employee ID, col B is Dept name. i want to search col B, match it with the employee ID in col A. i have several other sheets so that each sheet shows only the employee IDs for one particular dept. so far i have used a simple if(dept="marketing",a1,"--"). i am not too sure how to use vlookup in this case. also i dont want to skip rows. this is what i am getting with my formula sheet 1 sheet 2 sheet 3 1012 Acct -- 1012 acct 1064 Marketing 1064 marketing -- 2066 Admin -- -- 5066 Acct -- 5066 acct 6654 Marketing 6654 marketing -- sorry this post is longwinded, but i thought i'd give as much b/ground info as possible. thanx thomas. -- thomasNg ------------------------------------------------------------------------ thomasNg's Profile: http://www.excelforum.com/member.php...fo&userid=8375 View this thread: http://www.excelforum.com/showthread...hreadid=487834 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Distributing values from rows to columns for Access import | Excel Worksheet Functions | |||
| Finding a match in several columns | Excel Worksheet Functions | |||
| MATCH function - 2 columns w/ SIMILAR, not EXACT data | Excel Worksheet Functions | |||
| Totalling values across columns | Excel Worksheet Functions | |||
| Creating a chart with values from two columns | Charts and Charting in Excel | |||
Threaded Mode
