View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
maperalia maperalia is offline
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