View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mllestecchino
 
Posts: n/a
Default VLOOKUP Question

I'm having trouble getting the VLOOKUP function to work.

=VLOOKUP(LEFT(C2,2),'Expense Categories'!B2:C11,2)

Basically, I have a four digit string in column C. I want to match the first
two digits against the two digit numbers I have in Table B2:C11 on another
sheet, then have it return the text string in the second column of that table.

Right now, I keep getting "#N/A" no matter what I do. I've tried changing
the cell formats from text to number to general and still N/A. What am I
doing wrong here?

Thanks!
mllestecchino