Find cell address and return value in cell to the right

[Billdub417]

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

thanks in advance

 

[Skybluekid]

Are you able to put all the values in a proper data set?

Budget Actual
Person 1
Person 2