Forum Discussion

Copper Contributor

Dec 05, 2023

Help with a formula ChatGPT can't get correct either

Hi there. I hope someone can help me, because after trying 20 times myself and asking ChatGPT for help, I still do not have the correct answer. Ok, here goes: A postal code consisting of 5 di...

excel

Formulas and Functions

office 365

Lorenzo

Silver Contributor

Dec 05, 2023

Hi Camperslaolie

It'll difficult/inaccurate with a bunch of duplicates:

When above issue is fixed:

- Name B2:Z5 as (i.e.) Zones

in A10

=LET(
  rw, SUM( ISNUMBER( SEARCH(LEFT(B9,2),Zones) ) * SEQUENCE(ROWS(Zones)) ),
  IF(rw, "Zone " & rw, "Not found")
)

Sample_Camperslaolie.xlsx11 KB

Camperslaolie

Copper Contributor

Dec 06, 2023

thanks L.z. ... Duplicates indeed are incorrect.
I will check once more and try again 🙂