I'm soooo stuck...#N/A being returned on blank cells in my formula

On Sheet 2, I have a drop down list (via validation) in cell D6...then I have the validation list for D6 in Sheet 1 (A1:A7). In Sheet 1 (B1:B7) is a list of account #'s to correspond to A1:A7 that populate E6. If the cell in column D is blank, the cell in E6 is appearing with a #N/A. Does that make sense? Here is the formula that I am using in Column E on Sheet 2..... =INDEX(Sheet1!$A$1:$B$7, MATCH(D6, Sheet1!$A$1:$A$7, 0), 2)

did you try to add iferror and "" to the equation? I'm not really good at working with index and match but I would think it could be added to the calculation here =iferror(INDEX(Sheet1!$A$1:$B$7, MATCH(D6, Sheet1!$A$1:$A$7, 0), 2),"")

Makes sense to me, the blank will be interpreted as 0 and the MATCH won't find a match so will return #N/A.

If you don't want the #N/A add a test for a blank cell.

Formula:

Please Login or Register  to view this content.