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 h...
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!
