Index Statement Help Please

[nancybrown]

My index statement returns a value of #N/A or 0 for unmatched records. Can something be added to my formula below that will return a "blank" for unmatched items?

INDEX(SHEET2!$E$3:$E$10,MATCH(SHEET1!$A$1:$A$30,SHEET2!$A$1:$A:$30,0))

Many, many thanks!

 

[Diablo II]

remove the 0 at the end and put "".

 

[Aladin Akyurek]

My index statement returns a value of #N/A or 0 for unmatched records. Can something be added to my formula below that will return a "blank" for unmatched items?

INDEX(SHEET2!$E$3:$E$10,MATCH(SHEET1!$A$1:$A$30,SHEET2!$A$1:$A:$30,0))

Many, many thanks!

If on Excel 2007 or beyond...

=IFERROR(INDEX(SHEET2!$E$3:$E$10,
  MATCH(SHEET1!$A$1:$A$30,SHEET2!$A$1:$A:$30,0)),"")

Otherwise:

=IF(ISNUMBER(MATCH(SHEET1!$A$1:$A$30,SHEET2!$A$1:$A:$30,0)),
   INDEX(SHEET2!$E$3:$E$10,
      MATCH(SHEET1!$A$1:$A$30,SHEET2!$A$1:$A:$30,0)),"")

 

[VoG]

Try

=IF(ISNA(MATCH(Sheet1!$A$1:$A$30,Sheet2!$A$1:$A$30,0)),"",INDEX(Sheet2!$E$3:$E$10,MATCH(Sheet1!$A$1:$A$30,Sheet2!$A$1:$A$30,0)))

 

[nancybrown]

I should have thought of that . . . .a little slow to the gate!!!!

Thanks so much!