Hi, In a sheet1 there are 10 employees with ecodes (1,2,3,4,5....10)
In another sheet2 there are 5 employees with ecodes (1,2,3,4,5)
Out of 5, 2 employee cells are hidden (2,4)
Now using vlookup on sheet1 we need to get only names of ecodes (1,3,5) whereas ecodes (6,7,8,9,10) gives #NA as there are no details of ecodes on sheet2.
Please someone share a sheet or reply on how to not get values that are hidden while using vlookup.
From India, Hyderabad
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.