How to Use an Alphanumeric Mix in VLOOKUP Statements in Excel. ... This method finds one specific item of data and is most ... Replace "F4" with the address of the upper-left cell from the array ...