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