In another worksheet, I have a table sorted in ascending order. Table has
four columns. The first column has my lookup information in it, and the
other three, is the informatin that I am trying to get into another workbook.
But all I get is #N/A.

Example: In [spreadsheet A] there is a table that has in col 1 a list of
names, col 2 through 4 has a set of numbers. Now in [spreadsheet B], I am
trying to use the vlookup function to tell it what to look for in spreadsheet
A. My problem is how do I tell it what col to go to in [spreadsheet A] to
get the number needed, if [spreadsheet B] has a match with [spreadsheet A]
table.