Hi Team,
I hope anyone can help me with below requirement. When we do vlookup ...we only get value based on look up or same row values based on the position of the column.
I need something different like need to get the values based look up and next lookup value should not be same value ...and...
I need a formula for searching. Its an assignment:
A customer wants appointment at a specific date and time for a specific Doctor.
Say, For D0004 (Doctor Id) at 21/12/2014 07:00PM
I have another sheet which have list of Past and future appointments with columns "Appointment ID,Doctor Id,Date...
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.