Vlookup help please!

Georgina Thurlow

Bank Holiday Reference Sheet Smartsheet.JPG

Formula Smartsheet.JPG

For some reason I can't get a V-Lookup to work when referencing another sheet. In the first attachment I am showing the formula. My intention is to look up the country (Mexico in line 1) against a separate Smartsheet showing the bank holidays for all countries and return the bank holiday. The formula I am attempting to enter is: =VLOOKUP([Country]1, {Bank Holidays - Mar-21 Range 1}, 2, false) - however, it keeps changing to =VLOOKUP(Country1, {Bank Holidays - Mar-21 Range 1}, 2, false) and then returning "#INVALID COLUMN" error. I have also attached a screenshot of the bank holiday reference sheet that I am using to pull the data. 

Grateful for any help received! Thanks

Bassam Khalil

Hi @Georgina Thurlow

Hope you are fine, as i see from the screenshot you attached the formulas must be as following:

1- {Bank Holidays - Mar-21 Range 1} is contained the columns from ( Country To Bank Holidays 3)

2-Bank Holidays 1 =VLOOKUP(Country@row, {Bank Holidays - Mar-21 Range 1}, 9)

3-Bank Holidays 2 =VLOOKUP(Country@row, {Bank Holidays - Mar-21 Range 1}, 10)

4-Bank Holidays 3 =VLOOKUP(Country@row, {Bank Holidays - Mar-21 Range 1}, 11)

and for sure it must be DATE type columns. then the formula will work without any problem

Andrée Starå

Hi @Georgina Thurlow

I hope you're well and safe!

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Bassam Khalil

Hi @Georgina Thurlow

Hope you are fine, as i see from the screenshot you attached the formulas must be as following:

1- {Bank Holidays - Mar-21 Range 1} is contained the columns from ( Country To Bank Holidays 3)

2-Bank Holidays 1 =VLOOKUP(Country@row, {Bank Holidays - Mar-21 Range 1}, 9)

3-Bank Holidays 2 =VLOOKUP(Country@row, {Bank Holidays - Mar-21 Range 1}, 10)

4-Bank Holidays 3 =VLOOKUP(Country@row, {Bank Holidays - Mar-21 Range 1}, 11)

and for sure it must be DATE type columns. then the formula will work without any problem

Georgina Thurlow

Hi Bassam and Andrée,

Thank you for coming back to me!

Bassam, I hadn't formatted the cells to dates - thank you so much for pointing this out!

The formula now works 😀

Have a great day,

Georgina

Bassam Khalil

@Georgina Thurlow

You are welcome, happy that the formula now works with you.

Andrée Starå

@Georgina Thurlow

Glad you got it working!

You're more than welcome!