Mar 01 2021 03:54 AM - edited Mar 01 2021 04:48 AM
Hi all, my formula works if I enter it individually but as soon as I combine into one then it adds instead of using the scenarios, any advice on how to bring two scenarios together in one formula?
The scenarios - if Q15=3 then the answer must return the values as per vlookup but if Q15=4 then it should return another value as per vlookup.
=IF(R15=3,0,0)+VLOOKUP(E16,'Point System'!U:Y,4,0)AND/OR(IF(R15=4,0,0)+VLOOKUP(E16,'Point System'!U:Y,5,0))
Mar 01 2021 04:54 AM
Solution=VLOOKUP(E16,'Point System'!U:Y,R15+1))
Mar 01 2021 05:01 AM
Jan 16 2022 10:07 PM - edited Jan 16 2022 10:13 PM
@Hans Vogelaarme again. I want to change the statement to use two scenarios in one vlookup, is that possible? I want to lookup the account number and month of billing to give me a result. Taking into consideration is that a date is used.
=VLOOKUP(Acc number,'Source'!B:B,)&VLOOKUP(Month,'Source'!A:D,4,0)
=VLOOKUP(B2,'Source'!B:B,)&VLOOKUP(A2,'Source'!A:D,4,0)
Jan 17 2022 05:53 AM
I'm afraid that I don't understand. Could you try to explain in more detail, perhaps with a screenshot or attaching a sample workbook?
Jan 17 2022 11:50 AM
Perhaps
=IFNA( INDEX( Source!D:D, MATCH(1, INDEX( (Source!A:A = A2)*(Source!B:B = B2), 0), 0 ) ), "no such" )
Jan 17 2022 11:46 PM
@Sergei Baklan I will use this one and see if it returns the value that I am looking for. Thank you.
Mar 01 2021 04:54 AM
Solution