If there is not a match between I6 and anything in A1:A14988, then you'll see
what looks like an empty cell (that empty "" string).

Debra Dalgleish has lots of notes on =vlookup() he
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://contextures.com/xlFunctions02.html#Trouble


FP Novice wrote:

I am looking up data on another spreadsheet within the same document and I am
not getting any results returned. Can a formula expert look to see what I am
doing wrong please?

Spreadsheet with formula is named Index:

Cell H6 =IF(ISERROR(VLOOKUP(I6, List!$A$1:$C$14988,3,FALSE)),"",VLOOKUP(I6,
List!$A$1:$C$14988,3,FALSE))

Cell I6 = Data input 1 through 720

Cell J6
=IF(ISERROR(VLOOKUP(I6,List!$A$1:$C$14988,2,FALSE) ),"",VLOOKUP(I6,List!$A$1:$C$14988,2,FALSE))

Spreadsheet with data is named List:

Column 1(A) is number listing 1 down to 720
Column 2(B) is text
Column 3(C) is text

--

Dave Peterson