IF statement VLOOKUP reference to other sheets

Hello,

I am looking to create a VLOOKUP reference to other sheets based on a date column. I think I am pretty close but still getting #INVALID OPERATION

=IF([Date Agreed]@row = >31 / 11 / 2023, (VLOOKUP(Neutral@row, {2022/23 Mediator List Range 1}, 6, false)), (VLOOKUP(Neutral@row, {Copy of 2022/23 Mediator List Range 1}, 6, false)))

I can't see any problems with either the IF statement or the VLOOKUP!

Help please!

Karen

Find more posts tagged with

Accepted answers

Nick Korna

@klangridge103846,

There is a slight issue: November only has 30 days in it so 31/11/2023 isn't a valid date! Try amending to

=IF([Date Agreed]@row >= DATE(2023, 11, 30), (VLOOKUP(Neutral@row, {2022/23 Mediator List Range 1}, 6, false)), (VLOOKUP(Neutral@row, {Copy of 2022/23 Mediator List Range 1}, 6, false)))

This should get rid of the invalid operation - if there are any problems due to the VLOOKUPS etc. then just post!

All comments

Nick Korna

@klangridge103846,

There is a slight issue: November only has 30 days in it so 31/11/2023 isn't a valid date! Try amending to

=IF([Date Agreed]@row >= DATE(2023, 11, 30), (VLOOKUP(Neutral@row, {2022/23 Mediator List Range 1}, 6, false)), (VLOOKUP(Neutral@row, {Copy of 2022/23 Mediator List Range 1}, 6, false)))

This should get rid of the invalid operation - if there are any problems due to the VLOOKUPS etc. then just post!

klangridge103846

You are an angel! I feel very silly now! Thank you so much

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.