Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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.
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.
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
https://www.mrexcel.com/forum/excel-...ells-only.html
Thanks and Regards,
Akash Sharma
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.
Add the url of this thread if you want to cite this discussion.
Listed Under City-India-Hyderabad Country-India mis report excel calculations
Employee excel sheet.xls
