How do I get value from header match

kitsa

Board Regular
Joined
Mar 4, 2016
Messages
111
Office Version
  1. 365
  2. 2016
Hi,
I'm not sure how I get value from header match e.g. I need a criteria to match header with a cell, if match want to get a value of a sum cell, how would I write a formula?

as per pic:
Column A is the criteria to match Row 1 (E1:J1)
Give me answer Row 9 (E9:J9) if match, answer to B2:B5

Match header.JPG
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Book1
ABCDEFGHIJ
1Header NameQtyDateBobPeterJonesAdamJohnPaul
2Bob2281/02/202210020200209010
3Peter3672/02/2022505636035010
4Jones7713/02/202220115432010
5Adam484/02/20221130664101558
65/02/20221280156200158
76/02/202215141810302569
87/02/202220156582312
9Total228367771484034327
10
Sheet1
Cell Formulas
RangeFormula
B2:B5B2=INDEX($E$9:$J$9,MATCH(A2,$E$1:$J$1,0))
E9:J9E9=SUM(E2:E8)
 
Upvote 0
Solution

Forum statistics

Threads
1,215,261
Messages
6,123,942
Members
449,134
Latest member
NickWBA

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top