cancel
Showing results for
Did you mean:
Highlighted
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 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
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion

## Re: Vlookup in 3 columns

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")

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍

Regards,
Pranit

12 REPLIES 12
Highlighted
Community Champion

## Re: Vlookup on 3 columns

Hi @sbhan4

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")

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍

Regards,
Pranit

Highlighted
Helper V

## Re: Vlookup on 3 columns

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

Highlighted
Community Champion

## Re: Vlookup in 3 columns

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")

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍

Regards,
Pranit

Highlighted
Solution Sage

## Re: Vlookup on 3 columns

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

Highlighted
Community Champion

## Re: Vlookup on 3 columns

Thank you @VijayP

I have updated the formula.

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍

Regards,
Pranit

Highlighted
Continued Contributor

## Re: Vlookup on 3 columns

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")
Highlighted
Helper V

## Re: Vlookup on 3 columns

@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.

Highlighted
Helper V

## Re: Vlookup on 3 columns

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

Highlighted
Continued Contributor

## Re: Vlookup on 3 columns

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

#### Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors