|
|
|
|
#1
03-09-2006, 04:38 PM
|
||||
|
||||
40 43 45 49
Group 1 10 20 30 40 Group 2 12 22 32 42 Group 3 14 24 34 44 Group 1 =MATCH(A6,A1:A4) 45 =HLOOKUP(C6,B1:E4,B6) A6 has the dropdown menu B6 has the Match formula C6 has the drop down menu for the top row D6 has the final result, the Hlookup formula 40 43 45 49 Group 1 10 20 30 40 Group 2 12 22 32 42 Group 3 14 24 34 44 Group 1 2 45 30 :P 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Email w/ large attachement stuck in Outbox. Please Help!
|
smoky | Outlook | 11 | 07-20-2010 02:11 PM |
|
Excel Formula Help
|
Shahzad | Excel | 1 | 12-07-2008 04:13 AM |
|
OUTLOOK 2003 - Send/Receive "stuck"
|
frankalbo | Outlook | 1 | 09-10-2008 05:28 PM |
| formula in excell | curlymal | Excel | 2 | 02-09-2007 11:34 AM |
| Mailmerge Formula | mridley | Mail Merge | 0 | 07-27-2006 03:16 AM |
Windows 7 32bit 
Office 2007
Hybrid Mode