Hello Group.
I have the following delima, I keep getting lost in my formula. basically a bunch of if statements with iserror and vlookup.
Scenario
I have 3 Data Tables
Each Table has a date and name field.
I have a calendar heading that basically needs to pull the data from those 3 data tables for the specific date(s) on the calendar, and either just display the name of a specific date that may be in the data table, or concatenate the names separated by a /.
Table Names are as follows: Holidays, EventDates, BirthDays
Here is what I currently have for a formula but so far I've lost myself and am getting an error during testing.
=IF(ISERROR(AND(B$7=VLOOKUP(B$7,Holidays,1,0),B$7=VLOOKUP(B$7,EventDates,1,0),B$7=VLOOKUP(B$7,BirthDays,1,0))),IF(ISERROR(AND(B$7=VLOOKUP(B$7,Holidays,1,0),B$7=VLOOKUP(EventDates,1,0))),CONCATENATE(VLOOKUP(B$7,Holidays,2,0), " / ",VLOOKUP(B$7,EventDates,2,0)),IF(ISERROR(AND(B7=VLOOKUP(B7,Holidays,1,0),B7=VLOOKUP(B7,BirthDays,1,0))),CONCATENATE(VLOOKUP(B7,Holidays,2,0), " / ", VLOOKUP(B7,BirthDays,2,0)),)),CONCATENATE(VLOOKUP(B$7,Holidays,2,0), " / ",VLOOKUP(B$7,EventDates,2,0), " / ",VLOOKUP($B$7,BirthDays,2,0)))
Bookmarks