Display URL when condition met

Nilesh

Hello Experts,

i have two sheet having unique column app name, i have URL column to capture data.

i tried - if([app1]@row = {app2} ," https:URL", "")

i want to show the URL when app1 and app2 are matched otherwise i want to show blank.

JSanita

may be just be a little syntax issue.

Does this help?

=IF([app1]@row = [app2]@row, "https:URL", "")

Nilesh

Its same, if([app1]@row = {app2} ," https:URL", "")

app2 is coming from another sheet thats why its showing {app2}

Julio S.

Hi Nilesh,

The result in your formula will depend on what is being referenced in the cross-sheet reference. If this is a whole Column, it is expected that no match is going to be found. Your formula would work if the referenced content would be a single cell as my example below but this would require you to insert different references in each formula which may not be ideal:

Depending on how the second sheet is configured, it is possible that a VLOOKUP or an INDEX(MATCH()) may better accomplish what you intend as in my example below (which you can then convert to a Column Formula):

With the above, if there isn't a matching app in the "app 2" column from sheet 2, values in URL column won't be populated (will be left blank)

I hope that this can be of help

Cheers!

Julio