Thread: [Solved] Stuck on this formula!!!!
View Single Post
 
Old 03-09-2006, 03:36 PM
CADmanJP CADmanJP is offline
Novice
 
Join Date: Mar 2006
Posts: 2
CADmanJP
Default Stuck on this formula!!!!

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!!!!
Reply With Quote