Help with formula

cerilouise88

New Member
Joined
Jan 18, 2021
Messages
2
Office Version
  1. 2016
Platform
  1. 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
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Welcome to MrExcel Message Board.
Please Upload Example file & Desired results with XL2BB ADDIN(Preferable) or upload at free hosting Site e.g. www.dropbox.com , GoogleDrive or OneDrive & insert Link here.
 
Upvote 0
Welcome to MrExcel Message Board.
Please Upload Example file & Desired results with XL2BB ADDIN(Preferable) or upload at free hosting Site e.g. www.dropbox.com , GoogleDrive or OneDrive & insert Link here.
i have installed the XL2BB but dont now have the option to add it to my reply and its a work laptop so wont allow me to down load the free hosting site on here
 
Upvote 0
you don't need download at free hosting site, only open it at chrome or firefox , ... and upload example excel file on it then insert link here.
Are you don't have google account? if yes go to https://drive.google.com/drive/my-drive it is your google drive you can upload your file
after uploaded right click and get Link and copy link and Paste here.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,255
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top