Workday and Vlookup to select a range of holiday dates

Hi all

I need your help on the workday function.

For each country in column A, I have a range of holiday dates on the corresponding row (from column B to E for ex)

I would like to use the workday function, and include all the holiday dates corresponding to a country.

I first tried to use vlookup("country name", column A to E, ...) but the problem is that Vlookup returns only one cell value. And I would need it to return the range of holiday dates so that I can upload this range of holiday dates into my workday function.

Do you guys have any ideas how to write this ?

In CC an example.

Thanks

Thanks it works perfectly