Returning a matching column of cells

morashid99

New Member
Joined
May 19, 2019
Messages
1
How do I return a column of cells whose row headers match my lookup value in Excel?

<strike></strike>
<strike></strike>
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,564
The image is too small for me to read clearly, but it looks like either a VLOOKUP or SUMIF would work.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,676
Messages
5,470,082
Members
406,680
Latest member
Cleudson Dias de Almeida

This Week's Hot Topics

Top