![]() |
#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!!!! |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
smoky | Outlook | 11 | 07-20-2010 02:11 PM |
![]() |
Shahzad | Excel | 1 | 12-07-2008 04:13 AM |
![]() |
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 |