Forum Discussion
how do i locate a certain number in a grid?
this is probably a stupid question & is something i should know how to do.
i have a grid that looke something like this
24 25 26 27
1 2 3 4
4 4 4 4
5 6 7 8
8 8 8 8
9 10 11 12
13 14 15 16
how do i get it to find a certain number in the grid & return the number at the top?
i can set the row number from a formula in a different cell but the numbers in the grid are "fluid" & wont always be in the same place
5 Replies
- You have to specifically define the location of your lookup number. If, for example, you are looking for the number 4 in your given data, you have to specify which 4 is that. Otherwise, Excel cannot exactly determine which 4 you are looking for. Even without Excel, you cannot identify which 4 because there are 5 4’s in your data. If you cannot possibly identify it, you cannot also identify which formula to use, and inevitably, Excel has no way by which your desired result could be returned!
