Hi,
Having a challenge getting a lookup to work. Researching Offset appears to be the code required but I can't get this to work so any help appreciated. I am looking to have a multiple reference to a column based on the column title and the row content
i.e. If I enter 'United_Kingdom_Grade' in one cell and '2:1' in another cell it will look up and return B+. Likewise, if I change this to 'Angola Grade' and '12-16' it would return B+. There are more country grades but trying to keep it in concept. Thanks for any and all help.
United_States_of_America_Grade United_Kingdom_Grade Angola_Grade
A 1st 16-20
B+ 2:1 12-16
I hope the query makes sense but any questions, please shout.
Bookmarks