LOOKUP REPT one row not updating

Hi guys,

I have a master tab with data I am inputting in a row everytime, which is supposed to feed into a 2nd tab, titled case form (auto populated). On the case form tab, row 7, my data =LOOKUP(REPT("z",255),Master!M:M) just does not update sometimes! all the other cells referenceing data from the master tab works fine. Can anyone suggest a more stable formula please? I use text with multiple lines on the master tab, maybe this is causing an issue? or it is the 255? I don't know.

THANK YOu!

It work fine here. But you may try helper cell

D1
=MATCH(9^9,Master!F:F) or
=MATCH("Ω",Master!F:F)

Alt+234 for omega sign ="Ω" > rept("z",255) =TRUE


B2 =INDEX(Master!F:F,D1)
C1 =INDEX(Master!E:E,D1)

and so on for other cells

Originally Posted by Bo_Ry

It work fine here. But you may try helper cell

D1
=MATCH(9^9,Master!F:F) or
=MATCH("Ω",Master!F:F)

Alt+234 for omega sign ="Ω" > rept("z",255) =TRUE


B2 =INDEX(Master!F:F,D1)
C1 =INDEX(Master!E:E,D1)

and so on for other cells

Hi Bo_ry

sorrry but I am unable to follow your steps, can you maybe put this on one line or in the spreadsheet? never heard of the omega sign! Btw just to clarify I am querying cell B7 on the case form tab - that's the issue!

thank you!

We use rept("z",255) for lookup value because this has Greater than any text but "Ω" is greater than rept("z",255)

Please see attached

D1
=MATCH(9^9,Master!F:F)
E1
=MATCH("Ω",Master!F:F)

Originally Posted by Bo_Ry

We use rept("z",255) for lookup value because this has Greater than any text but "Ω" is greater than rept("z",255)

Please see attached

D1
=MATCH(9^9,Master!F:F)
E1
=MATCH("Ω",Master!F:F)

Got it thanks so much! rep added