tkroper
Active Member
- Joined
- Feb 2, 2007
- Messages
- 255
I'm using this formula (thanks to dafan & HalfAce http://www.mrexcel.com/forum/showthread.php?p=1604964&posted=1#post1604964)
to return the value located in the 3rd column of the range when the value in the 1st column of the range matches the data in A177.
However, there isn't a match for the data in A178 in the range, so the formula returns "#N/A". I would like the cell containing the formula to remain blank in those instances. Is there a way to do this?
Thank you very much for your help!
Todd
Code:
=IF(VLOOKUP($A177,$A$736:$C$787,3,FALSE)=0,"",VLOOKUP($A177,$A$736:$I$787,3,FALSE))
However, there isn't a match for the data in A178 in the range, so the formula returns "#N/A". I would like the cell containing the formula to remain blank in those instances. Is there a way to do this?
Thank you very much for your help!
Todd