Syntax for IF THEN LOOKUP Formula

[DH888]

I'm trying to get this formula to work

=IF<gs id="5461d56c-5950-4f91-9baa-9b56a75f907c" ginger_software_uiphraseguid="77d9f4c7-ac77-48b5-a140-55f4b681acf1" class="GINGER_SOFTWARE_mark">(</gs>((LOOKUP<gs id="89f5118e-7bd1-4de8-b39f-6a37284babd3" ginger_software_uiphraseguid="77d9f4c7-ac77-48b5-a140-55f4b681acf1" class="GINGER_SOFTWARE_mark">(</gs>2,1/(P5<gs id="c91407af-fe6d-4641-9631-3523941496ab" ginger_software_uiphraseguid="77d9f4c7-ac77-48b5-a140-55f4b681acf1" class="GINGER_SOFTWARE_mark">:</gs>P35<>"")<gs id="35cb9ff3-15d1-467c-bef4-de9dcadc7dca" ginger_software_uiphraseguid="77d9f4c7-ac77-48b5-a140-55f4b681acf1" class="GINGER_SOFTWARE_mark">,</gs>P5<gs id="e68ed770-7336-4862-98a9-e6f537b12b02" ginger_software_uiphraseguid="77d9f4c7-ac77-48b5-a140-55f4b681acf1" class="GINGER_SOFTWARE_mark">:</gs>P35))""),""<gs id="4752ae0d-f315-4cc0-9251-5d116e628d21" ginger_software_uiphraseguid="77d9f4c7-ac77-48b5-a140-55f4b681acf1" class="GINGER_SOFTWARE_mark">,</gs>LOOKUP<gs id="cd017937-5316-47a1-b853-1966d3288d86" ginger_software_uiphraseguid="77d9f4c7-ac77-48b5-a140-55f4b681acf1" class="GINGER_SOFTWARE_mark">(</gs>2,1/(P5<gs id="806d19ac-b220-4a3f-a6cf-16b7ac779d1a" ginger_software_uiphraseguid="77d9f4c7-ac77-48b5-a140-55f4b681acf1" class="GINGER_SOFTWARE_mark">:</gs>P35<>"")<gs id="d173896f-d8a5-4e33-bca1-56b2fce8bf74" ginger_software_uiphraseguid="77d9f4c7-ac77-48b5-a140-55f4b681acf1" class="GINGER_SOFTWARE_mark">,</gs>P5<gs id="4aca2364-85bb-460c-8e59-5c51e8c6c067" ginger_software_uiphraseguid="77d9f4c7-ac77-48b5-a140-55f4b681acf1" class="GINGER_SOFTWARE_mark">:</gs>P35)
in cell P36 at the bottom of the YTD column

[TABLE="class: grid, width: 500, align: right"]
<tbody>[TR]
[TD]2[/TD]
[TD="align: center"]O[/TD]
[TD="align: center"]P[/TD]
[/TR]
[TR]
[TD]3
4[/TD]
[TD="align: center"]Daily Over/Short[/TD]
[TD="align: center"]MTD Cash[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]$5.00[/TD]
[TD]$5.00[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]33[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]34[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]35[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]36[/TD]
[TD][/TD]
[TD]=IF<gs id="6621a8fe-5f11-49c4-8abe-43b17a34241a" ginger_software_uiphraseguid="10052bbc-4571-424c-98ee-e58f362b8530" class="GINGER_SOFTWARE_mark"><gs id="96b1d408-dc19-44b3-951e-79be55c4e29a" ginger_software_uiphraseguid="63eb24ed-63d4-4529-a4ac-8b69ec62d8bb" class="GINGER_SOFTWARE_mark">(</gs></gs>(LOOKUP<gs id="558b0b8d-8e03-4185-add4-c44f140c4de8" ginger_software_uiphraseguid="10052bbc-4571-424c-98ee-e58f362b8530" class="GINGER_SOFTWARE_mark"><gs id="a63b56ba-7f09-4646-8862-de0f8c1624a6" ginger_software_uiphraseguid="63eb24ed-63d4-4529-a4ac-8b69ec62d8bb" class="GINGER_SOFTWARE_mark">(</gs></gs>2,1/(P5<gs id="793763ca-dd04-425c-b007-3af533727727" ginger_software_uiphraseguid="10052bbc-4571-424c-98ee-e58f362b8530" class="GINGER_SOFTWARE_mark"><gs id="6bf55182-d019-4069-99c7-4875097a5f21" ginger_software_uiphraseguid="63eb24ed-63d4-4529-a4ac-8b69ec62d8bb" class="GINGER_SOFTWARE_mark">:</gs></gs>P35<>"")<gs id="b311a5cf-2c1f-4fc2-a956-394249326f3f" ginger_software_uiphraseguid="10052bbc-4571-424c-98ee-e58f362b8530" class="GINGER_SOFTWARE_mark"><gs id="91634331-455b-4f13-afa1-3a6fffa9cba1" ginger_software_uiphraseguid="63eb24ed-63d4-4529-a4ac-8b69ec62d8bb" class="GINGER_SOFTWARE_mark">,</gs></gs>P5<gs id="84cf09ff-a623-46b2-b985-5f7e89607757" ginger_software_uiphraseguid="10052bbc-4571-424c-98ee-e58f362b8530" class="GINGER_SOFTWARE_mark"><gs id="f56e9972-db19-4fcf-ab22-0ed3e3d010ee" ginger_software_uiphraseguid="63eb24ed-63d4-4529-a4ac-8b69ec62d8bb" class="GINGER_SOFTWARE_mark">:</gs></gs>P35),"","")<gs id="b88adcce-fc61-4351-b361-b39d613b3d77" ginger_software_uiphraseguid="10052bbc-4571-424c-98ee-e58f362b8530" class="GINGER_SOFTWARE_mark"><gs id="fbada0d6-d415-40a2-8596-70c5cbad5972" ginger_software_uiphraseguid="63eb24ed-63d4-4529-a4ac-8b69ec62d8bb" class="GINGER_SOFTWARE_mark">,</gs></gs>(LOOKUP<gs id="72b4c5b0-94dc-48b8-b08f-5ffa469d4151" ginger_software_uiphraseguid="10052bbc-4571-424c-98ee-e58f362b8530" class="GINGER_SOFTWARE_mark"><gs id="6f3962d5-8fd5-4760-8805-09bad3e7edcf" ginger_software_uiphraseguid="63eb24ed-63d4-4529-a4ac-8b69ec62d8bb" class="GINGER_SOFTWARE_mark">(</gs></gs>2,1/(P5<gs id="a225f61c-ac4b-44d2-ba07-0134ee4c346e" ginger_software_uiphraseguid="10052bbc-4571-424c-98ee-e58f362b8530" class="GINGER_SOFTWARE_mark"><gs id="eaa2a807-0a76-4385-ac2b-ea960c2f085a" ginger_software_uiphraseguid="63eb24ed-63d4-4529-a4ac-8b69ec62d8bb" class="GINGER_SOFTWARE_mark">:</gs></gs>P35<>"")<gs id="13192c00-de36-4103-9658-e561a182b660" ginger_software_uiphraseguid="10052bbc-4571-424c-98ee-e58f362b8530" class="GINGER_SOFTWARE_mark"><gs id="8c8078be-44b7-4e67-b300-16a3db7d514e" ginger_software_uiphraseguid="63eb24ed-63d4-4529-a4ac-8b69ec62d8bb" class="GINGER_SOFTWARE_mark">,</gs></gs>P5<gs id="bf113cae-c7ab-4f3f-987b-4975846995d0" ginger_software_uiphraseguid="10052bbc-4571-424c-98ee-e58f362b8530" class="GINGER_SOFTWARE_mark"><gs id="8e9fd99c-9fd7-4073-9dff-154bd03c6c28" ginger_software_uiphraseguid="63eb24ed-63d4-4529-a4ac-8b69ec62d8bb" class="GINGER_SOFTWARE_mark">:</gs></gs>P35))[/TD]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]




















































Currently it's just saying the formula contains an error
Thanks in advance for your help

 

[Aladin Akyurek]

If you are looking for the last numeric value in P5<gs class="GINGER_SOFTWARE_mark" id="c91407af-fe6d-4641-9631-3523941496ab" style="background-color: transparent; color: rgb(51, 51, 51); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; orphans: 2; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; word-wrap: break-word;" ginger_software_uiphraseguid="77d9f4c7-ac77-48b5-a140-55f4b681acf1">:</gs>P35, try...

=IFERROR(LOOKUP(9.99999999999999E+307,P5<gs class="GINGER_SOFTWARE_mark" id="c91407af-fe6d-4641-9631-3523941496ab" style="background-color: transparent; color: rgb(51, 51, 51); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; orphans: 2; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; word-wrap: break-word;" ginger_software_uiphraseguid="77d9f4c7-ac77-48b5-a140-55f4b681acf1">:</gs>P35),"no number")

If you are looking for last text value in P5<gs class="GINGER_SOFTWARE_mark" id="c91407af-fe6d-4641-9631-3523941496ab" style="background-color: transparent; color: rgb(51, 51, 51); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; orphans: 2; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; word-wrap: break-word;" ginger_software_uiphraseguid="77d9f4c7-ac77-48b5-a140-55f4b681acf1">:</gs>P35, try...

=IFERROR(LOOKUP(REPT("z",255),P5<gs class="GINGER_SOFTWARE_mark" id="c91407af-fe6d-4641-9631-3523941496ab" style="background-color: transparent; color: rgb(51, 51, 51); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; orphans: 2; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; word-wrap: break-word;" ginger_software_uiphraseguid="77d9f4c7-ac77-48b5-a140-55f4b681acf1">:</gs>P35),"no text")


If you are looking for any last value in P5<gs class="GINGER_SOFTWARE_mark" id="c91407af-fe6d-4641-9631-3523941496ab" style="background-color: transparent; color: rgb(51, 51, 51); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; orphans: 2; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; word-wrap: break-word;" ginger_software_uiphraseguid="77d9f4c7-ac77-48b5-a140-55f4b681acf1">:</gs>P35, try...


=IFERROR(LOOKUP(9.99999999999999E+307,1/P5<gs class="GINGER_SOFTWARE_mark" id="c91407af-fe6d-4641-9631-3523941496ab" style="background-color: transparent; color: rgb(51, 51, 51); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; orphans: 2; overflow: visible; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; word-wrap: break-word;" ginger_software_uiphraseguid="77d9f4c7-ac77-48b5-a140-55f4b681acf1">:</gs>P35,P5:P35),"no value")​

​

​