Forum Discussion
Find the column and row number in an excel spread sheet based on criteria.
Hi Good day, I am looking for a way to find the address of a cell based on a criteria. I am having specific data placed randomly in sheet 1 of a workbook in different columns and rows. (like Apple,...
=ADDRESS(MIN(IF(sheet1!A1:H100=J1,ROW(1:100))),MIN(IF(sheet1!A1:H100=J1,COLUMN(A:H))))An alternative with e.g. Excel 2013 could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021. The search value is in cell J1 and the range in sheet1 is A1:H100 in this example. The range in sheet1 can be adapted as required.