Mere pass multiple product hai aur usaki loc multiple locations main hai aur kuch loc abhi empty hai par main jab bhi vlokup lagata hu to mujhe empty pehali loc deta hai aur mujhe jaha pe product hai wah loc chahiye ise kaise solve kar sakte hai Excel main kaun se formula laga sakte hai
Through VLOOKUP, it will always picks the first value chahe wo blank ho ya fir non blank. Create a new unique column (concat of product and loc) and then use VLOOKUP based on those 2 columns.
Call us at +91-9354674901 for
Advanced Excel LIVE Training,
Excel Automation, Excel Dashboards, and Power BI assistance. 😀😀👍
Very nice
Good job bro just keep it up 👍👍👍👍
Thank you Rohit Kumar!
Nice sir keep it up
Amit Jain, Thank You!
Sir more if sheet please
Hi sir help chahiye apaki
Mere pass multiple product hai aur usaki loc multiple locations main hai aur kuch loc abhi empty hai par main jab bhi vlokup lagata hu to mujhe empty pehali loc deta hai aur mujhe jaha pe product hai wah loc chahiye ise kaise solve kar sakte hai Excel main kaun se formula laga sakte hai
Through VLOOKUP, it will always picks the first value chahe wo blank ho ya fir non blank. Create a new unique column (concat of product and loc) and then use VLOOKUP based on those 2 columns.
@@MDataFinnovatics thanks sir
=IF(AND(B2="Finance",C2>5,D24,D25,D2