The reason my formula returns 15 instead of 14 is that I understood you
wanted to add 1 to the result. In any case, let's see if I understand
you correctly...

1) You'd like to search for the Numeric Label 14.

2) The Numeric Label 14 is found at Column 16.

3) The corresponding Numeric Value is 2.

4) You'd like to add 1 to that value, which gives you 3.

5) You'd like to search for the first column that contains a value that
is greater than or equal to 3 (Numeric Value +1), starting from Column
15 and moving to the left.

6) This brings us to Column 14. But here I thought you wanted to add 1,
which would give you a result of 15. Did you in fact want to add 1?

7) If there's no value greater than or equal to 3 (Numeric Value +1),
you'd like to search for the Numeric Label (14).

8) You'd like to searching for the Numeric Label (14), starting from
Column 1 and moving right.

9) Now here's where I think I may have misunderstood. When searching
for the Numeric Label (14), are you still checking Row 11 (starting from
Column 1 and moving right) or are you now checking Row 10 (starting from
Column 1 and moving right)?

In article <5a59ef0b48d5b@uwe, "Sam via OfficeKB.com" <u4102@uwe
wrote:

Based on the Sample Data below: can you see if you get Numeric Label 14
(currently housed in Column Number 16) and its Numeric Value to Return a
Column Number of 14 using the current Formulae.

Sample Data:
Column Number 1 Row 10 Houses Numeric Label 0
Column Number 1 Row 11 Houses Numeric Value 16

Column Number 2 Row 10 Houses Numeric Label 2
Column Number 2 Row 11 Houses Numeric Value 12

Column Number 3 Row 10 Houses Numeric Label 1
Column Number 3 Row 11 Houses Numeric Value 10

Column Number 4 Row 10 Houses Numeric Label 4
Column Number 4 Row 11 Houses Numeric Value 9

Column Number 5 Row 10 Houses Numeric Label 6
Column Number 5 Row 11 Houses Numeric Value 9

Column Number 6 Row 10 Houses Numeric Label 12
Column Number 6 Row 11 Houses Numeric Value 7

Column Number 7 Row 10 Houses Numeric Label 8
Column Number 7 Row 11 Houses Numeric Value 6

Column Number 8 Row 10 Houses Numeric Label 3
Column Number 8 Row 11 Houses Numeric Value 5

Column Number 9 Row 10 Houses Numeric Label 5
Column Number 9 Row 11 Houses Numeric Value 5

Column Number 10 Row 10 Houses Numeric Label 9
Column Number 10 Row 11 Houses Numeric Value 5

Column Number 11 Row 10 Houses Numeric Label 11
Column Number 11 Row 11 Houses Numeric Value 5

Column Number 12 Row 10 Houses Numeric Label 7
Column Number 12 Row 11 Houses Numeric Value 4

Column Number 13 Row 10 Houses Numeric Label 13
Column Number 13 Row 11 Houses Numeric Value 4

Column Number 14 Row 10 Houses Numeric Label 15
Column Number 14 Row 11 Houses Numeric Value 3

Column Number 15 Row 10 Houses Numeric Label 10
Column Number 15 Row 11 Houses Numeric Value 2

Column Number 16 Row 10 Houses Numeric Label 14
Column Number 16 Row 11 Houses Numeric Value 2

Column Number 17 Row 10 Houses Numeric Label 18
Column Number 17 Row 11 Houses Numeric Value 2

Based on the above Sample Data, I would expect Numeric Label 14 to Return
Column Number 14 as the correct Result using the SEARCH order: Descending for
Numeric Value and Ascending for Numeric Label.

Your original A1 style notation Formula provided a Result closer to the
Expected Result and made reference to the COLUMN Function (not sure if
relevant).

The A1 style notation Formula below (still using sample data above) will
Return a Column Number Result of 15 for Numeric Label 14. However, the
correct Result required is Column Number 14 using the SEARCH order:
Descending for Numeric Value and Ascending for Numeric Label.