Hi - would appreciate help with this one. I want to use a standard Excel function to solve a lookup based on criteria problem...
I have a 'key' on worksheet(1) with (let's say) 2 columns A & B - example values as follows (approx 75 in total).
GIAA 50%
GIAB 100%
GYEFF 80%
etc...