Hey guys if I could get some help with a formula that would be great! So basically what I need is "Our policy is 2 different stays maximum in a lifetime" So I have a check_in 1, check_out 1, check_in 2, check_out 2 box in excel. What I need is a formula that basically grabs anytime that their name is mentioned on the guest_Info sheet; it pulls the check in and check out days per person to be listed on the guest list. If that makes sense. Here is some mini sheets to take a look. I assume its going to be a v-lookup formula but not totally sure. And you may not understand what I'm saying, but here it is!
You can ignore the B column in Guest_List. Its C4,D4,E4, and F4. Filled all the way down. This will tell me if the person has had their 2 maximum lifetime stays! Once again the Guest_Info list starts at F4:V1000 for future entrys! Thanks for taking a look.
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.