Array formula? Help! Please

[jpreuss]

I am trying to pull information from one excel sheet to the other. 

Excel sheet 1 has all positions and salaries with the different locations

Excel sheet 2 only needs to pull the position and salary located in a specific location

I can not figure it out

[#2]

@jpreuss 

=VLOOKUP($H2&$I2&$J2,CHOOSE({1,2,3,4},$A$2:$A$15&$B$2:$B$15&$C$2:$C$15,$D$2:$D$15,$E$2:$E$15,$F$2:$F$15),COLUMN(B1),0)

Is this what you are looking for? If you don't work with Office365 or 2021 enter formula with ctrl+shift+enter.

[#3]

@OliverScheurich Yes, that is what i am trying to do. However, why is it to different formulas?