rebelhunter
New Member
- Joined
- Oct 24, 2002
- Messages
- 11
A B
NAME AGE
1 dan 10
2 john 15
3 shaun 18
4 dan 27
5 craig 35
6 dan 47
How can i use Vlookup to automatically find the figure in column b, row 4 everytime, within the above table, when the position of dan could change, if more names are added, but the above names stay constant and the figures change??
Regards,
Shaun
NAME AGE
1 dan 10
2 john 15
3 shaun 18
4 dan 27
5 craig 35
6 dan 47
How can i use Vlookup to automatically find the figure in column b, row 4 everytime, within the above table, when the position of dan could change, if more names are added, but the above names stay constant and the figures change??
Regards,
Shaun