View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sbellybutton sbellybutton is offline
external usenet poster
 
Posts: 4
Default get the VLOOKUP function to return the "contents" of a cell?

=VLOOKUP(B1:B730,Sheet2!A1:C216,2,1) returns #N/A. What am I doing wrong?
Row1 of my table is #s and row2 is letters. I need the 730 cells in rowB to
equal what is in my table! Help.