Oct 29 2021 08:35 AM
Hello. I need help with creating a formula to look at the input in two separate columns then return a value from a simple table. I've tried different ways based on my internet searches but they all involve using Index or Match or both, which I'm not opposed to, but I don't know how to use those features. I've attached an example. Thank you for your help.
Oct 29 2021 09:01 AM
Solution=VLOOKUP(A5&C5,CHOOSE({1,2},$I$5:$I$19&$J$5:$J$19,$K$5:$K$19),2,0)
Enter above formula as arrayformula with ctrl+shift+enter in D4 and copy down.
Oct 29 2021 09:07 AM
Oct 29 2021 09:13 AM
Glad it helped. With INDEX and MATCH it's:
=INDEX($I$5:$K$19,MATCH(A5&C5,$I$5:$I$19&$J$5:$J$19,0),3)
This has to be entered as arrayformula as well.
Oct 29 2021 09:01 AM
Solution=VLOOKUP(A5&C5,CHOOSE({1,2},$I$5:$I$19&$J$5:$J$19,$K$5:$K$19),2,0)
Enter above formula as arrayformula with ctrl+shift+enter in D4 and copy down.