Search value in Column specified in another cell
in this table I have:
Column "A": number of operations in the same day
Column "B": Date
Column "C:F": results
Column "G": formula that search if there's a previous positive result in same day
Column "J": manual column input
In the column "G" I have to manually change the column to search for, column "C"/"D"/"E" or"F"
=IF(AND(A2>1,C1=1),"ok","")
I want to be able to reference this formula to a cell so I just change cell "J1" with the column to search without modifying the formula.
For example: in cell "J1" I put "X", so in column "G" will be searching results in "D:D" with title "X"
I would use this formula to do what you need with the control you have. It checks the first column that it's over 1, then it does an index match to search the range for but matches the column so it knows which to search. The row()-1 is because the range starts one below the header, so you may need to adjust this if necessary.
=IF(AND($A2>1, INDEX($C$2:$F$5,ROW()-1,MATCH($J$1,$C$1:$F$1,0))=1),"ok","")
- How to change Chart xAxes font color from black to red via vba code?
- using VBA in Excel I would like to replace only blank cells with a formula without selecting all the time
- If value matches x, enter new value into another table using row and column matches
- Create a smaller dynamic list in Excel from data in a larger list using multiple criteria
- How to loop through dimetial array using VBA in excel?
- Correct calculation of r square (R^2) using visual basic WorksheetFunction.LinEst function
- Copy column data to new column, if data exists, use column to the right
- Best practice for checking if an cell entry will generate an error
- Spill formula to sumifs by row & col for only relevant months
- How to keep value of merged cells in each cell?
- Python - Automatically adjust width of an excel file's columns
- How to Define the row after Lastrow in VBA
- How to convert big numbers between HEX and DEC in Excel without using VBA?
- Preventing ClearContents on Combination of Merged and Unmerged Cells
- drop_duplicates not working in pandas?
- Word VBA: How to reference a Named Range/Cell from Excel so it returns the row number
- Convert excel to pdf with VBScript
- Forbidden custom function name in Excel
- copy file to a dynamic folder using VBA
- VB: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)
- Pie chart with three fields in Ms Excel
- Excel: Put formula in next row after header text, like in Google Sheets
- Copy cells based on matching index numbers on excel?
- Adding holiday parameter into NetworkDays function
- Split a cell into 2 rows in Excel
- How to Combine Text Based on Multiple Criteria in Excel
- The VBA code slows down the worksheet needs to be faster
- Dealing with struck-through and non-struck-through characters using Python on Linux and/or MacOS
- Renaming worksheets by VBA
- Add Table to Excel File with R, without overwriting excisiting content