Important: Make sure the values in the first row have been sorted in an ascending order. If you enter TRUE, or leave the argument blank, the function returns an approximate match of the value you specify in the first argument.

It's actually quite easy to do with a lookup function.The The Look Up London Live virtual tours are on hold for the time being while I focus on my Virtual Tour Membership but happily there are 25 tours exploring the hidden London neighbourhoods below! Because an exact match for "B" is not found, the largest value in row 1 that is less than "B" is used: "Axles," in column A.5=HLOOKUP("Bolts", A1:C4, 4)Looks up "Bolts" in row 1, and returns the value from row 4 that's in the same column (column C).11=HLOOKUP(3, {1,2,3;"a","b","c";"d","e","f"}, 2, TRUE)Looks up the number 3 in the three-row array constant, and returns the value from row 2 in the same (in this case, third) column. 0.4573.555000.5253.254000.6062.933000.6752.752500.7462.572000.8352.381500.9462.171001.091.95501.291.710 3115Atlanta4/7/12="Atlanta = "&INDEX($A$2:$C$33,MATCH("Atlanta",$B$2:$B$33,0),1)& ", Invoice date: " & TEXT(INDEX($A$2:$C$33,MATCH("Atlanta",$B$2:$B$33,0),3),"m/d/yy")3137Atlanta4/9/12="Austin = "&INDEX($A$2:$C$33,MATCH("Austin",$B$2:$B$33,0),1)& ", Invoice date: " & TEXT(INDEX($A$2:$C$33,MATCH("Austin",$B$2:$B$33,0),3),"m/d/yy")3154Atlanta4/11/12="Dallas = "&INDEX($A$2:$C$33,MATCH("Dallas",$B$2:$B$33,0),1)& ", Invoice date: " & TEXT(INDEX($A$2:$C$33,MATCH("Dallas",$B$2:$B$33,0),3),"m/d/yy")3191Atlanta4/21/12="New Orleans = "&INDEX($A$2:$C$33,MATCH("New Orleans",$B$2:$B$33,0),1)& ", Invoice date: " & TEXT(INDEX($A$2:$C$33,MATCH("New Orleans",$B$2:$B$33,0),3),"m/d/yy")3293Atlanta4/25/12="Tampa = "&INDEX($A$2:$C$33,MATCH("Tampa",$B$2:$B$33,0),1)& ", Invoice date: " & TEXT(INDEX($A$2:$C$33,MATCH("Tampa",$B$2:$B$33,0),3),"m/d/yy")3331Atlanta4/27/123350Atlanta4/28/123390Atlanta5/1/123441Atlanta5/2/123517Atlanta5/8/123124Austin4/9/123155Austin4/11/123177Austin4/19/123357Austin4/28/123492Austin5/6/123316Dallas4/25/123346Dallas4/28/123372Dallas5/1/123414Dallas5/1/123451Dallas5/2/123467Dallas5/2/123474Dallas5/4/123490Dallas5/5/123503Dallas5/8/123151New Orleans4/9/123438New Orleans5/2/123471New Orleans5/4/123160Tampa4/18/123328Tampa4/26/123368Tampa4/29/123420Tampa5/1/123501Tampa5/6/12 See more.

This means that the column containing the value you look up should always be located to the left of the column containing the return value. Because an exact match for "B" is not found, the largest value in row 1 that is less than "B" is used: "Axles," in column A.