Soldato
- Joined
- 26 Apr 2004
- Posts
- 6,165
- Location
- Wrexham
Say for example i have an excel spreadsheet with the following columns in:
NAME | ADDRESS | AGE
further down the page a field where i can enter someones name.
What i would like is 3 lookup formulae that will return the Name, Address and Age (in seperate cells of course) for people with said name (using the field i specified).
Problem is that sometimes someones name appears twice, with different information, so i need something that can go into the formula that when it is copied into the cell below, it checks if the info it is going to return is the same as above, and if it is, return the next set of data that applies to the person of that name.
Possible? Im stuck!
NAME | ADDRESS | AGE
further down the page a field where i can enter someones name.
What i would like is 3 lookup formulae that will return the Name, Address and Age (in seperate cells of course) for people with said name (using the field i specified).
Problem is that sometimes someones name appears twice, with different information, so i need something that can go into the formula that when it is copied into the cell below, it checks if the info it is going to return is the same as above, and if it is, return the next set of data that applies to the person of that name.
Possible? Im stuck!