Excel formula help, No VBA please

  • Thread starter Thread starter bill_ball
  • Start date Start date
B

bill_ball

Hello everybody,

I need your assistance.... No VBA help please

I have columns A,B,C,D,E,F........................AG.... in sheet1.
everyday data gets populated in row1 of every column from A to AG.

I want to know the formula to fetch the column number where "Bil
Amount" in row1 of sheet1 is populating

sometimes "Bill Amount" may come at Column D, sometimes in Column
etc.

i want a formula to look for "Bill Amount" in all the columns of row
and returns the column number.

thanks in advance
 
=match("bill amount",1:1,0)


bill_ball said:
Hello everybody,

I need your assistance.... No VBA help please

I have columns A,B,C,D,E,F........................AG.... in sheet1.
everyday data gets populated in row1 of every column from A to AG.

I want to know the formula to fetch the column number where "Bill
Amount" in row1 of sheet1 is populating

sometimes "Bill Amount" may come at Column D, sometimes in Column K
etc.

i want a formula to look for "Bill Amount" in all the columns of row 1
and returns the column number.

thanks in advance.
Click to expand...
 
Back
Top