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
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.
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!
Hi Khalil
I had previously answered your first question before. Refer to the link below.
https://www.myonlinetraininghub.com/excel-forum/excel/vlookup-using-dates-with-if-and-if-and-formula
Sunny
Yeah I saw that one too! But if our man has seen it and used it? We maybe never know......
