## Help with Index Formula

4StarLounger
Posts: 455
Joined: 30 Mar 2010, 18:49
Location: United States

### Help with Index Formula

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
Posts: 72885
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

### Re: Help with Index Formula

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)
Regards,
Hans