If INDEX,MATCH function returns 0, can I change it to use value from adjacent cell?

**giallofever** · 03-16-2009, 12:46 PM

Hi,

If a INDEX,MATCH function returns a zero, how do I get it to use the value in the adjacent cell which is a unique number?

=INDEX(Sheet2!A:C,MATCH(A2,Sheet2!A:A,0),3)

Example:

Please Login or Register  to view this content.

To change the 0 in B3 to whatever is in A3.

Thanks,
Chris

**alski** · 03-16-2009, 12:50 PM

How about an If statement?

=if(INDEX(Sheet2!A:C,MATCH(A2,Sheet2!A:A,0),3)=0,A1,INDEX(Sheet2!A:C,MATCH(A2,Sheet2!A:A,0),3))

**giallofever** · 03-16-2009, 01:09 PM

Thank you for the formula. I was looking between IF, ISERROR, etc.

=IF(INDEX(Sheet2!A:C,MATCH(A2,Sheet2!A:A,0),3)=0,A2,INDEX(Sheet2!A:C,MATCH(A2,Sheet2!A:A,0),3))

Problem is SOLVED!

Thanks,
Chris

If INDEX,MATCH function returns 0, can I change it to use value from adjacent cell?

LinkBack

Thread Tools

Rate This Thread

Display

If INDEX,MATCH function returns 0, can I change it to use value from adjacent cell?

Re: If INDEX,MATCH function returns 0, can I change it to use value from adjacent cel

Re: If INDEX,MATCH function returns 0, can I change it to use value from adjacent cel

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions