cerilouise88
New Member
- Joined
- Jan 18, 2021
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Hi
I have a table with a column that needs information pulling from a row, the row information is also in a merged cell i will try to paste the sheet so it makes sense. I am trying to find a way to get the info from one to the other but also allow me to drag the formula down so I don't need to manually write this for each result. Any help would be greatly appreciated i have tried Hlookup but I can't seem to get it to work
Just in case the image doesn't work, i want the xxxx on the left to show the results going to the right
leave percentage 10% 20% 10%
xxxxxxx
xxxxxxx
xxxxxxx
xxxxxxx
xxxxxxx
xxxxxxx
I have a table with a column that needs information pulling from a row, the row information is also in a merged cell i will try to paste the sheet so it makes sense. I am trying to find a way to get the info from one to the other but also allow me to drag the formula down so I don't need to manually write this for each result. Any help would be greatly appreciated i have tried Hlookup but I can't seem to get it to work
Just in case the image doesn't work, i want the xxxx on the left to show the results going to the right
leave percentage 10% 20% 10%
xxxxxxx
xxxxxxx
xxxxxxx
xxxxxxx
xxxxxxx
xxxxxxx