Billdub417
New Member
- Joined
- Nov 5, 2019
- Messages
- 45
Hello, as per the below, i have a sheet showing a page of info about different people.
On a second sheet i have a list of the people: Person1, Person 2 etc and want to be able to quickly pull through the "Actual" result.
Is there a way to lookup (for example) "person 6" across multiple columns and return the "Actual" result shown underneath?
Very sorry, XL2BB doesnt seem to be working for me hence the image![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
thanks in advance
On a second sheet i have a list of the people: Person1, Person 2 etc and want to be able to quickly pull through the "Actual" result.
Is there a way to lookup (for example) "person 6" across multiple columns and return the "Actual" result shown underneath?
Very sorry, XL2BB doesnt seem to be working for me hence the image
![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
thanks in advance