How to return the column header when "Yes" is found in a specific row in another table?
I'm trying to figure out a formula to return whether or not a ClassID is eligible for a program or not.
Matching the ClassID on sheet 2 with sheet 1, and returning the head of the column from sheet 1 if there is a yes anywhere in the row of that ClassID. Or a No if there is not.
The caveat is there are multiple instances of the ClassID in sequential rows on sheet 2.
Solution
You can try:
=IFERROR(INDEX($A$1:$G$1,1,AGGREGATE(15,6,COLUMN(A:G)/(INDEX(A:G,MATCH(J2,A:A,0),0)="Yes"),1)),"No")
- Dynamically create variables in for loop
- openxlsx currency style - Is there a rounding option?
- Last key of a Dictionary Excel VBA
- Leave out quotes when copying from cell
- php generating excel and downloading
- How to generate an .xlsx using php
- VBA if cells between number values then delete row
- Create a new table using multiple columns from a list of data that has repeating values in it
- Lookup multiple criteria
- Pandas Styler.bar() not showing on Excel column
- Indicate when there is no match when comparing Excel data to Access recordset
- Difference between 'on error goto 0' and 'on error goto -1' -- VBA
- How to return the column header when "Yes" is found in a specific row in another table?
- VBA Number of rows based on number
- Speed up nested loop in VBA
- Conditional formatting highlight non matching criteria based on min date
- Is it possible to read the value of the Office Theme option that's currently applied in the Microsoft Excel settings and use it in VBA?
- Return all column headers when there are multiple yes entries from a vlookup
- VBA set a dynamic range based on “unique” IDs in a column
- Character encoding in Excel spreadsheet and what Java charset to use to decode it
- Disable warning about Excel text cell containing numeric value in OfficeOpenXml
- Excel LAMBDA + spill
- Using Excel Lambda function to count numbers that meet a condition (in conjunction with groupby)
- How do I filter results from a list based on previously-filtered results?
- Sort rows based on multiple criteria
- Convert Range to a table
- Problems with Excel handling of the month of March in German language
- Excel IF multiple columns
- Increase row height of Excel cell (merged cell & text wrapped), if cell has multiple lines
- Copy Formula To Multiple Cells Using EPPlus