=IF(VLOOKUP(B4,'Multiple Cases'!$A$2:$D$19,1,FALSE)=B4,(VLOOKUP(B4,'Multiple Cases'!$A$2:$D$19,2,FALSE)),"")
I am still new to excel, and can not seem to figure out why this formula is not working correctly. if the vlookup finds a match on the Multiple cases Sheet it will return the correct information using the second vlookup statement, but when there is no match I would like the cell to remain blank. In stead it is just giving me #N/A when blank.
Bookmarks