Help with Index Formula

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

Help with Index Formula

Post by 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))

User avatar
HansV
Administrator
Posts: 72885
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Help with Index Formula

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

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

Re: Help with Index Formula

Post by bradjedis »

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