Forum Discussion
Finding the next value in list - nothing to match off of
Hi Everyone, Bit of a tricky one but I'll do my best to explain my issue. I have a list starting at B1 to B26. B1 is "A-A", B2 is "A-B", B3 is "A-C" etc. all the way to "A-Z". In A1 I want t...
I recommend sharing the sample via OneDrive or another host. You may also send the file via private message.
This formula will work for column P.
=LET(demo,IF(G5="ladies","womens",IF(G5="pre-boys","toddlers",G5)),XLOOKUP($K5,WORKINGS!$A$2:$A$55,XLOOKUP(demo&"*",WORKINGS!$L$1:$P$1,WORKINGS!$L$2:$P$55,"",2)))
Uploading the workbook in case there's more and I'm not able to get to it.