Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 11:37 PM.


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