Be careful with hlookup and vlookup guys. Data needs to be sorted in ascending order which sometimes is inconvenient. Index-match is the method I use these days - see
Say Goodbye to VLOOKUP, and Hello to INDEX-MATCH | eImagine Technology Group for a good explanation.