VLOOKUP formula to copy values from one sheet to another

Hey Guys,

I Have a sheet name "Holiday", and I want to copy the cols "Country", "Start Date" and "End Date" from this sheet to another (empty) sheet called "Holidays Israel", BUT only the rows that thier country is Israel. I tried VLOOKUP (this is the formula I used: =VLOOKUP("Israel", {Holidays Range 3}, 5) but when I drag the formula to the rows below it copies the same one date.

How can I copy all the different dates which belong to Israel?

Attaching screenshots

This is the "Holidays" sheet

this is the sheet I want to copy the dates to:

Thank you!

Find more posts tagged with

Accepted answers

All comments

David Tutwiler

I would use the Copy Row automation. If you set it for something like "When rows are added or changed" and when Country = Israel, then it should move any new holidays over to your new sheet.

In order to get it to take your existing rows, you could go and rename your country from Israel to "I" and click save, then go back and change them back to "Israel" and click save 1 last time. That should move all of your rows to your new sheet.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.