Hi all,
I've been trying to get a function to work all day today and I didn't get very far.
I was wondering if there is a way to consolidate data from an input to be renamed to an output by referencing it from another list.
I've left what I was working on at work but I was playing with IF statements, trying to use MATCH, and about 4 other ways. I could never seem to get the list to work off a reference list, mainly because I don't think IF statements like using A1:A10 selection. I did get something working by manually typing each 'class', but it would make it hard to update it as required.
I'll post what I did last night, but if someone could have a look at my excel, it shows my input and desired output as well as a reference list.
Cheers
Bookmarks