Vlookup on 3 columns

[sbhan4]

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 no	Lenth	width	Height	Result
1233	3	0	5	NO
1234		8	6	NO
1235	2	3	4	YES
1236			2	NO
1237	1	2	3	YES

[darentengmfs]

@sbhan4 

You're looking for an IF statement and not a vlookup..?

If so, create a new column

Result = IF(OR(OR('Table'[Height]=0,ISBLANK('Table'[Height])),or(OR('Table'[Length]=0,ISBLANK('Table'[Length])),OR('Table'[Width]=0,ISBLANK('Table'[Width])))),"NO","YES")

[sbhan4]

@darentengmfs Vlookup or ef else anything is fine. The REsult should come to like that

[darentengmfs]

@sbhan4 

Please try my formula in the reply above.

[pranit828]

Hi @sbhan4 

Please make sure your three number columns are of number type.

Measure = IF(SELECTEDVALUE(table[Length]>0 || SELECTEDVALUE(table[width]>0 || SELECTEDVALUE(table[Height]>0, "YES","NO")

OR

Measure = IF(ISBLANK(SELECTEDVALUE(table[Length]) || ISBLANK(SELECTEDVALUE(table[width]) || ISBLANK(SELECTEDVALUE(table[Height]) || SELECTEDVALUE(table[Length] = 0 || SELECTEDVALUE(table[width] = 0 || SELECTEDVALUE(table[Height] = 0, "NO","YES")

[sbhan4]

@pranit828 Hi Pranit,

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

[sbhan4]

@pranit828 Thanks. Didn't work for me. Can you provide me pbix file for it?

[pranit828 · Accepted solution]

Hello @sbhan4

Your question is unclear, do you have two tables or do you want the calculation in a single table.

My answer was for a table and I misplaced OR instead of y.

Medida: IF(SELECTEDVALUE(table[Length])>0 && SELECTEDVALUE(table[width])>0 && SELECTEDVALUE(table[Height])>0, "YES","NO")

O

Measurement: IF(ISBLANK(SELECTEDVALUE(table[Length]) ISBLANK(SELECTEDVALUE(table[width]) ISBLANK(SELECTEDVALUE(table[Height]) SELECTEDVALUE(table[Length]) ? 0 ? SELECTEDVALUE(table[width]) to 0 ? SELECTEDVALUE(table[Height]) to 0, "NO","YES")

[sbhan4]

@pranit828 It worked well. Thank you.

[VijayP]

@sbhan4 

Formula given by @pranit828  works perfectly,

@pranit828  you have missed closing Parthese after each Selected value that is creating problem to him

Just Rewrite the Fucntion and Share

[sbhan4]

@VijayP  Thank you, Vijay! I have provided brackets as well but didn't work for me. Can you please try this out in pbix file.

[VijayP]

@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

[pranit828]

Thank you @VijayP 

I have updated the formula.