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
Hi, good question asked, below link is a bit confusing but maybe you might understand it:
https://www.mrexcel.com/forum/excel-...ells-only.html
Thanks and Regards,
Akash Sharma

From India, Delhi

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.

Please Login To Add Reply






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2021 CiteHR.Comô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server