Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-09-2006, 03:36 PM
CADmanJP CADmanJP is offline
Novice
Stuck on this formula!!!!
 
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
  #2  
Old 03-09-2006, 04:38 PM
davesexcel's Avatar
davesexcel davesexcel is offline Stuck on this formula!!!! Windows 7 32bit Stuck on this formula!!!! Office 2007
Novice
 
Join Date: Mar 2006
Posts: 7
davesexcel is on a distinguished road
Default

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 :P
Reply With Quote
  #3  
Old 03-10-2006, 02:06 AM
CADmanJP CADmanJP is offline
Novice
Stuck on this formula!!!!
 
Join Date: Mar 2006
Posts: 2
CADmanJP
Default Got the answer

Thanks for your help, I don't think my explanation was clear enough.

However I found the answer from another post:

=Index(the table of values,match(group input,Group 1-3 column,0),match(numeric input,numeric row,0))

Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stuck on this formula!!!! Email w/ large attachement stuck in Outbox. Please Help! smoky Outlook 11 07-20-2010 02:11 PM
Stuck on this formula!!!! Excel Formula Help Shahzad Excel 1 12-07-2008 04:13 AM
Stuck on this formula!!!! 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft