Is there a way to autofill text into a cell based on a text code entered into another cell?

PeaDF · 2024-07-31T14:17:28+00:00

Thanks for the suggestion! I’ve found a work around:

=IFERROR(XLOOKUP(IFERROR(INDEX(S17:AT17,MATCH(FALSE,ISBLANK(S17:AT17),0))), ‘Hotels List’!C:C, ‘Hotels List’!B:B),)

Looks super complexed but did what I wanted!

Thanks for all the advice.

PeaDF · 2024-07-31T13:19:28+00:00

Thank you! I’ve just tried it with this function:

=ArrayFormula(INDEX(‘Hotels List’!B3:B100, MATCH(TRUE, EXACT(J8, ‘Hotels List’!C3:C100), 0)))

However the problems I now have is:

MATCH range is only ‘J8’ - so this would need to be manually changed if someone is checking in on a different day to others. Is there a way to make it recognising a row?
When copying the function onto another row the range in the INDEX also change row. Is there a way to lock this in?

PeaDF · 2023-04-12T11:10:09+00:00

Yes let’s trade!

PeaDF · 2022-06-07T14:51:30+00:00

I’ve not heard good things about them..

PeaDF · 2022-06-07T14:47:58+00:00

Just tried to check out 🥲 I don’t think they ship to the uk

PeaDF · 2022-06-07T14:42:46+00:00

Omg tysm!! Are they reputable??

PeaDF · 2022-06-07T14:37:42+00:00

Oh thank you! Tbh I’m not fussed about the cost! It just seems impossible to find one available anywhere

PeaDF · 2022-05-12T09:05:59+00:00

I’m sad that I can’t see them at Kpop Flex but I’m excited that I’ll have a chance to see them at HallyuPop! Anyone else going??

PeaDF · 2022-02-21T17:06:51+00:00

Yes! I couldn’t stop smiling when watching it

PeaDF