Help with Index Formula

[bradjedis]

Greetings, I currently have this formula. All works great. I am wondering if it is possible to have it display nothing, if the target cell is blank?
So if the data in CR Raw Data'!I:I is blank, the resultant would be displayed as blank. Right now if it is blank, it is populating a zero.



=INDEX('CR Raw Data'!I:I,MATCH(CRs!A26,'CR Raw Data'!A:A,0))

[HansV]

If the target cell contains a text value if it isn't blank, you can use

=INDEX('CR Raw Data'!I:I,MATCH(CRs!A26,'CR Raw Data'!A:A,0))&""

If it might contain numbers, use

=IF(INDEX('CR Raw Data'!I:I,MATCH(CRs!A26,'CR Raw Data'!A:A,0))="","",INDEX('CR Raw Data'!I:I,MATCH(CRs!A26,'CR Raw Data'!A:A,0)))

Instead of INDEX('CR Raw Data'!I:I,MATCH(CRs!A26,'CR Raw Data'!A:A,0)), you can also use VLOOKUP(CRs!A26,'CR Raw Data'!A:I,9,FALSE)

[bradjedis]

Sorry for delay. Just got back to this project. This solution worked great! Thanks Hans