Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CADmanJP
 
Posts: n/a
Default 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


--
CADmanJP
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davesexcel
 
Posts: n/a
Default 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)

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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=520917

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default 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

(remove ^^ from email address)

Portland, Oregon




"CADmanJP" wrote in message
...

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


--
CADmanJP


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 06:30 AM
A Formula required - please! Anthony Excel Discussion (Misc queries) 2 July 21st 05 10:11 AM
Formula assistance required!!! Don Excel Discussion (Misc queries) 4 February 22nd 05 09:34 PM
addition to my date formula...required Juco Excel Worksheet Functions 5 January 30th 05 12:48 PM
Rate of return required formula Alorasdad Excel Worksheet Functions 1 November 18th 04 04:14 AM


All times are GMT +1. The time now is 03:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"