Returning a matching column of cells

M

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?

main-qimg-e4810245463897ceedf3bb6e53978a70
<strike></strike>
​
<strike></strike>
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Sort by date Sort by votes
The image is too small for me to read clearly, but it looks like either a VLOOKUP or SUMIF would work.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
Clear Entire Row if Checkbox Selected
Replies
5
Views
160
kevin9999
K
E
  • Solved
Slow file using index/match calculations
Replies
8
Views
737
Fluff
Fluff
szita2000
  • Question
Index Match Match from a named table to a range
Replies
1
Views
275
Alex Blakenburg
A
L
  • Question
VBA script to remove excel striked out text (partial) inside each cell.
Replies
1
Views
330
learningpython
L
A
  • Question
Index and Match for 2No criteria only partially returning values other values #ref error.
Replies
6
Views
122
roelandwatteeuw
R

Forum statistics

Threads
1,214,588
Messages
6,120,409
Members
448,959
Latest member
camelliaCase

Share this page

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