Hi, I can not find any function for this problem, the formula should find a number in a different excel sheet and when find the specified number in the cell then give us the first cell in that column. Example: I need the formula that will refer to source excel file and find BD/3298-1 in whole list and it will give me that column title which in this case is CELL
Solved by S. Q. in 17 mins