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