Workday - Select range of holidays with Vlookup

[vadius]

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 ?

Thanks

 

[drsarao]

Try this:
OFFSET(A1,MATCH("country name",A:A,0)-1,1,1,4)

The 4 in above formula is for the 4 columns B to E. (Can be changed)

 

[vadius]

Thanks !

 

[drsarao]

You are welcome.