Return value that need to satisfy condition. | General Excel Questions & Answers

Return value that need to satisfy condition.

Ahmad Khalil Che Ab Aziz

Member

Members

Forum Posts: 4

Member Since:
June 16, 2015

Offline

February 22, 2017 - 1:02 pm

Hi,

Based on the attachment how to return value in another table if we need to satisfy the condition as follows:

If Cell is TRUE then only return value in the specific table.

Condition based on the attached excel sheet: How to return value in Table H5:H11 in Column E4:E28 using VLOOKUP if D4:D28 is TRUE and C4:C28 match G5:G11 . If D4:D28 = FALSE then return value 0 (ZERO)

Thank you and Regards.

Khalil

Frans Visser

Duivendrecht (near Amsterdam) - The Netherlands

Member

Members

Dashboards

Power BI

Power Query

Forum Posts: 227

Member Since:
April 21, 2015

Offline

February 22, 2017 - 8:39 pm

Try this (example in cell E4 from your second attachment (the one with version v1 in the name):

=IF(D4=TRUE;VLOOKUP(C4,$G$4:$H$11,2,0),"0")

Where the last zero is with tekstmarkers so it becomes only the zero. You can also place only the zero number there, but then the answer will be 0% in the cells where the IF don't match.

Hope this helps you?

EDIT: here also the attachment, hope translation from Dutch goes well.

Frans Visser

Duivendrecht (near Amsterdam) - The Netherlands

Member

Members

Dashboards

Power BI

Power Query

Forum Posts: 227

Member Since:
April 21, 2015

Offline

March 8, 2017 - 2:11 am

Hi Ahmad Khalil Che Ab Aziz,

I'm always interested if the suggestion helped you or if you need further assistance? Would be kind hearing from you!