![]() |
|
#1
|
|||
|
|||
|
Help!!! I've tried everything but can't get the formula I need to do the following: I have a table as follows 40 43 45 49 Group 1 10 20 30 40 Group 2 12 22 32 42 Group 3 14 24 34 44 On my spreadsheet I will manually input a Group number and also the value 40 (or 43,45,49). Now in another cell, B1 I want to create a formula that looks up which group I have typed in cell A1 e.g Group 2 and looks up which numeric value if I typed in cell A2 e.g. 43. I want the formula to return the answer 22 in cell B1. Please please can anyone help. I have tried Index's, Match's, Arrays. I am 80% there but can't finish!!!! |
|
|
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 |