Formula Question

[FP Novice]

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]

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() here:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://contextures.com/xlFunctions02.html#Trouble

 

[FP Novice]

Thanks Dave,

While I was waiting for a reply I figured it out, I had I6 set to text, as
soon as I set the formatting back to number it worked. I would like the
search to return the formatting that is associated with the cell on the other
spreadsheet but that is porbably asking to much...

 

[Dave Peterson]

Formulas only return values--they don't return formatting.