paldersley
New Member
- Joined
- Sep 13, 2006
- Messages
- 1
simple lookups are limited to either rows or columns, i want to find a particular value which may be anywhere within a defined range
i have tried offset and match, but i always need to know where the target is for these to work
eg where is 3
a b c e
1 0 0 0 0
2 1 0 3 1
3 0 1 2 0
4 5 0 0 0
i need formula to give me C2 which i can then use in a GO TO command, or anything that does the same thing
i have tried offset and match, but i always need to know where the target is for these to work
eg where is 3
a b c e
1 0 0 0 0
2 1 0 3 1
3 0 1 2 0
4 5 0 0 0
i need formula to give me C2 which i can then use in a GO TO command, or anything that does the same thing