You have not given us much to work with.
Suppose A1:F1 holds these values
100 110 120 130 140 150
And H1 hold the number 120 - the number you want to find
The the formula =MATCH(H1,A1:F1,0) will return 3 since the sought-after
number is in the third cell in the array A1:F1
Is this close to what you are trying to do?
best wishes
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
