Formula Question


F

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
 
Ad

Advertisements

F

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...
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP 4
Help with an IF Formula 5
Row #s Not Advancing When I Copy Formula 2
Excel Conditional formula for different scenarios 0
Formula 4
problem with formulas (2) 7
circular reference using vlookup 1
Stuck on formula 1

Top