Forum Discussion

Iron Contributor

Mar 01, 2021

Solved

combining two if statements in one with a vlookup

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

excel

HansVogelaar
Mar 01, 2021
Janedb

=VLOOKUP(E16,'Point System'!U:Y,R15+1))

Janedb

Iron Contributor

Jan 17, 2022

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

SergeiBaklan

Diamond Contributor

Jan 17, 2022

Janedb

Perhaps

=IFNA( INDEX( Source!D:D, MATCH(1, INDEX( (Source!A:A = A2)*(Source!B:B = B2), 0), 0 ) ), "no such" )

Janedb
Iron Contributor
Jan 18, 2022
SergeiBaklan I will use this one and see if it returns the value that I am looking for. Thank you.