I suggest you change it to this:

=VLOOKUP(A1,Sheet2!A$1:C$216,2,1)

entered in B1, then copy the formula down to row 730. I think you are
getting "rows" and "columns" mixed up in your description.

Hope this helps.

Pete


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.