Thread: [Solved] HLookup Formula
View Single Post
 
Old 12-12-2016, 06:18 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Or, if you prefer HLOOKUP:

=HLOOKUP("YR_"&$F$1,$A$1:$C$6,$G$1,0)

with 2 in G1.
Reply With Quote