find the column
hi there all, i'm new here, i joined this forum because i really believe that is a great forum to learn ideas in excel.
i have a sort of a problem now... i have a table list of numbers from column a to f, row 4 to row 9. I have a criteria cell in b12. in my list is numbers, how to find that number in the list equal to number in b12, then if found return the value in the row 2, ( contains some data ) in same column as the 'found' number is located.
thanks for help.
Do you mean something like ?
If the value occurs more than once it will return the first column heading in which the value is found.Code:=IF(COUNTIF(A4:F9,B12),INDEX(A2:F2,MIN(IF(A4:F9=B12,COLUMN(A4:F9)))),"N/A") confirmed with CTRL + SHIFT + ENTER
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks