cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Vlookup on 3 columns

Hi,

If a part no.  have Lenth, width height (not blank or zero any of the 3 columns) then YES else NO. I need your help.

 

Part noLenthwidthHeightResult
1233305NO
1234 86NO
1235234YES
1236  2NO
1237123YES
12 REPLIES 12
Highlighted

@sbhan4 

PFA

 https://drive.google.com/file/d/1aJ9AjE90eDNT8ufKLHo79YBZ90EuteXj/view?usp=sharing

@pranit828  Did Small Change SELECTEDVALUE not requried

@sbhan4  if you find this as solution please mention this as solution and share your Kudoes

Highlighted

@pranit828 It worked well. Thank you.

Highlighted

 

@pranit828 Hi Pranit,

 

Well formula should give me YES but giving me "NO". Any suggestions.

 

 

sbhan4_0-1601340942430.png

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors