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
6In 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
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.
#Subject List: City-India-Hyderabad Country-India mis report excel calculations
Employee excel sheet.xls
