Hi Paullaup,
Here is my way of doing this (and I use it a lot).
Just to mention: I don't like LOOKUP, VLOOKUP and HLOOKUP. I prefer combining INDEX with MATCH. I had a lot of trouble with LOOKUP (wrong results), in the MATCH command you can define better what happens if you donot find the...