Forum Discussion
searching two criteria to return a value
Hi, I need help to write a formula, as the function I would usually use doesn't work and I'm unsure on other functions. I have two worksheets and I need to pull information from worksheet 1 to...
=VLOOKUP(E3&F3,CHOOSE({1,2},$A$3:$A$13&$B$3:$B$13,$C$3:$C$13),2,FALSE)
You can apply VLOOKUP along with CHOOSE. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
OliverScheurich Thank you! this worked a treat 🙂