Formula Question
 

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

Formula Question
 

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

Formula Question
 

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" wrote:

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

Formula Question
 

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



FP Novice wrote:

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" wrote:

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


--

Dave Peterson