User Profile
venkatvedavyasan
Copper Contributor
Joined Mar 30, 2023
User Widgets
Recent Discussions
Need a formula to get the vlookup with multiple similar value
Hi, I have a list of people with full name and location. In the sheet I received I have only the last name and Location. What I want is to find the full Name with help of the last name and location. The issue I'm facing is that I have same Last name for multiple persons. I'm trying to use VLOOKUP but the it is returning wrong values. Data that I have with Full Name and Location Data I got with Last Name and LocationStationary Provisioning based on month
Hi, I'm trying to prepare a inventory which is quite big of which I have given a sample below. I have a data month wise where it says what item is provided to the department on which month Poduct April May June July August Pen G NG G NA NA Eraser NG NA NA G G Paper G NA G NG NA Paper clip NG NA NG G NA I want the day to be in two column data like below. Prduct Month Given NotGiven Pen April Given Pen May Not Given Pen June Given Eraser April Not Given Eraser July Given Eraser August Given Paper April Given Paper June Given Paper July Not Given Paper Clip April Not Given Paper Clip June Not Given Paper Clip July Given I tried Transpose but I'm not getting the option repeated. For example Pen was given in April and June and given in May, but I get only April. I don't have access to Macros so let me if we can achieve this through some formula or BI
