June 16, 2015
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
VIP
April 21, 2015
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.
VIP
April 21, 2015
VIP
Trusted Members
June 25, 2016
Hi Khalil
I had previously answered your first question before. Refer to the link below.
https://www.myonlinetraininghu.....nd-formula
Sunny
1 Guest(s)