Forum Discussion
#REF! and #N/A Error while using Vlookup to fetch value
Hey, Facing Ref error while fetching value. Source sheet is AR-216 and Main sheet where I want the value to go in is Sheet1. 1. I am able to get the rows with #ref! error but not with exact value....
Try it this way:
=IFERROR(VLOOKUP(B3,'AR-216'!$D$6:$E$16,2,0),"")The IFERROR(......,"") part makes sure that when a code is not found the cell is left blank.
And note that the #REF! errors were caused by the fact that the VLOOKUP functions was looking for the 3rd column in a range that only has two.
Thank you so much, all my problems are solved. I guess this would change my days work in a few hours. You people are great.
