VLOOKUP reference another sheet with parents

We are looking to create a formula to reference a date in another sheet (sheet 2) and than see if the referenced date in (Sheet 2)is before or after the date in the formula sheet (sheet 1).

Forcing a check box or adding a visual identifier to the formula if it is true would be ideal.

I've created this VLOOKUP formula, but keep getting '#UNPARSEABLE'.

Sheet 2 does have parents and children, I selected the children under one parent in the formula below.

=VLOOKUP([$House Number],{TEST_TVMFF Creation Tracker 2019_TEST Range 4}, [House Number]2 ,[false]

([$House Number], - the number in sheet 1

TEST_TVMFF Creation Tracker 2019_TEST - the name of sheet 2

[House Number]2 - the column number in sheet 2 I am looking to return the value of

[false] - exacte results

Thanks in advance.

Find more posts tagged with

Media & Entertainment

Comments

Paul Newcome

Two very minor and easy to miss things...

1: Your $ should be outside of the bracket

and

2: That same piece is missing a row number.

You have

[$House Number],

It should be

$[House Number]#

where # is replaced either by an actual number or the @row reference.

I am also unsure of your column number portion without being able to see some screenshots or something.

Cam_S

Thanks for the help Paul, I'll give it try with your suggestions.

Paul Newcome

Happy to help.

Sign in to join the conversation!

Quick Links

Trending discussions

Document filtered by form responses
I've created a Smartsheets form. When someone submits the form, I want them to automatically be emailed a document that has resources and links, but the document is filtered to only show the content that corresponds with what they selected in the form. Is something like this possible? What types of documents or automations…
Form stopped working after upgrade
I have a sheet that I created in a previous version, and it had a form. I was recently upgraded to a newer version and now my form is not working. I created a new form for the sheet, and it is giving me an error also. Does anyone know what I can do to fix this? The error says Form Unavailable. Sorry, the form you're trying…
Getting Error About Emulated Environments
Hi, I have read the post from 8/21/25. I am still getting the same error. I am setting up a new device and just download the latest version as of 9/5/25. I am using a Eunivon Smart White Board for touchscreen capability. It is running Android 14. Any help would be appreciated.