Remember Me?

#1
March 9th 06, 10:42 PM posted to microsoft.public.excel.worksheet.functions
Formula help required!!!

I have tried in vain to complete a correct formula for the following:

-----------40x-----43x-----45x-----49x
Group 1......10........20........30........40
Group 2......12........22........32........42
Group 3......14........24........34........44

I will manually type into Cell A1 the group I am using e.g. Group 2 and
into cell A2 the number x e.g. 43x.

Now in cell B1 I want the formula to return the answer 22.

Can anyone point me in the right direction and save me pulling my hair
out???

Thanks

--

#2
March 10th 06, 03:44 AM posted to microsoft.public.excel.worksheet.functions
 davesexcel Posts: n/a
Formula help required!!!

use this example I posted in your original post

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)

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

--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708

#3
March 10th 06, 03:45 AM posted to microsoft.public.excel.worksheet.functions
 Peo Sjoblom Posts: n/a
Formula help required!!!

Assume your table are in F1:J4 with Group1 starting in F2 going down to F4
and 40x in G1 going across to J1
then this formula will give you 22 if A1 is Group 2 and A2 is 43x

=INDEX(F1:J4,MATCH(A1,F1:F4,0),MATCH(A2,F1:J1,0))

for a generic formula that uses a named table see here

http://www.contextures.com/xlFunctio...ml#IndexMatch3

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

Portland, Oregon

...

I have tried in vain to complete a correct formula for the following:

-----------40x-----43x-----45x-----49x
Group 1......10........20........30........40
Group 2......12........22........32........42
Group 3......14........24........34........44

I will manually type into Cell A1 the group I am using e.g. Group 2 and
into cell A2 the number x e.g. 43x.

Now in cell B1 I want the formula to return the answer 22.

Can anyone point me in the right direction and save me pulling my hair
out???

Thanks

--

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Tenacity Excel Worksheet Functions 9 December 3rd 05 05:30 AM Anthony Excel Discussion (Misc queries) 2 July 21st 05 10:11 AM Don Excel Discussion (Misc queries) 4 February 22nd 05 08:34 PM Juco Excel Worksheet Functions 5 January 30th 05 11:48 AM Alorasdad Excel Worksheet Functions 1 November 18th 04 03:14 AM

All times are GMT +1. The time now is 06:06 AM.

The comments are property of their posters.