LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 258
Default Formula to Match Values

I wonder if you can help me to setup this formula.
I have values located in the excel cell as shown below:

A B C D E F G
1 bag 24 24 24 72 63 top
2 tube 24 24 21 69
3 cord 24 24 18 66
4 top 24 21 18 63
5 center 24 21 15 60
6 paper 24 21 12 57


Basically, what I am doing is:
1.- Taking the sum for each row (B+C+D).
2.- Compare and match values on the column "E" with the number located in
the cell €œ F1€.
3.- Write in the cell €œG1€ description (located in the column "A") of the
row found.

In my sample the selected row is number 5 which is cell €F1=63€ and cell €œH1
= top€.
Do you thing you can help me to get a formula to automate this procedure?

Thanks in advance.
Maperalia


 
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 formula not returning correct values. pm Excel Discussion (Misc queries) 1 January 30th 08 03:15 PM
how can we get unique values in match function for same match key. Xcel[_2_] Excel Worksheet Functions 11 December 7th 07 08:13 PM
Match Values in Rows with Partial Values in Columns ryguy7272 Excel Worksheet Functions 3 August 8th 07 05:14 PM
can you use the match formula to look for two different values? alpa Excel Worksheet Functions 1 April 21st 06 08:50 PM
Match formula that pulls unique values from another column? alehm Excel Discussion (Misc queries) 6 September 8th 05 10:38 PM


All times are GMT +1. The time now is 10:33 PM.

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

About Us

"It's about Microsoft Excel"