Thread: get the VLOOKUP function to return the "contents" of a cell?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default get the VLOOKUP function to return the "contents" of a cell?
=VLOOKUP(B1,Sheet2!$A$1:$C$216,2,1)

Copy down column B to B730

NOTE: B is a column, not a row


Gord Dibben MS Excel MVP


On Mon, 2 Oct 2006 16:42:01 -0700, sbellybutton
wrote:

=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.

Reply With QuoteReply With Quote