Forum Discussion
How to link written text (not numbers/data) in an excel sheet to another sheet?
I'm not quite sure how to explain what I'm trying to do, but I'll try. I'm trying creating a scope and sequence curriculum document (I'm a teacher) that will compile information for every grade level...
For your sample you may XLOOKUP() combination of B1 and A2 in second sheet (transforming "Grade 6" & "Unit 1" into "G6 Unit 1") in column A of the first sheet returning related value from column B.
That's better illustrate on the sample file if you provide it instead of screenshot.