View Single Post
  #8  
Old 08-18-2005, 04:29 PM
FatOtt FatOtt is offline
Junior Member
 
Join Date: Sep 2002
Posts: 11
Default Re: Tough Excel Question

Putting things in alphabetic columns like Excel does, you've got numbers in column A and letters in column B. Insert a column C that merges these two, so that cell C1=a1&b1. Then do your vlookup in column D on the value you desire from column C.

To create your lookup value, do the same thing, maybe in a row above the dataset. So insert 2 rows above all of your data. In cell A1, you will input the value from column A that you want. In cell B1, you will input the value from column B that you want. Cell C1 will = A1&B1. Your lookup formula will then reference C1. Or you can type the letter/number combination directly into the vlookup formula like you did in your example.

Edit: obviously not fast enough
Reply With Quote