Formula to find a relative position for a value in a row

[mwc0914]

Say I have a series of values in a row. I need a formula that will return the relative position of the value in the row...and I will occasionaly insert a column at the front of the row of values, so the relative position may be different tomorrow.

Foe example, say I have the following values in Row 1, columns B-F: 32,42,54,67,89
Say in cell A2 is where I need my formula to return the relative position of the value for 54. Today the answer would be 3.
Then say tomorrow I insert a new value (29) in Row 1, Column B...now I have values in columns B-G...so the relative position for 54 is now 4, which will now become the value in cell A2

[Chance2]

You could use the MATCH function:

Please Login or Register  to view this content.

Using the range of 1:1 allows you to add or delete columns and the -1 at the end accounts for column A (that you are not counting).

[NBVC]

Try

=Match(54,Index(A1:F1,1,2):F2,0)

[martindwilson]

another is
=MATCH(54,OFFSET(A1,,1,,255),0)