Populate from another worksheet if two fields match

[returnerjr]

I have two worksheets, and want to populate a field if two fields in one sheet match two fields in the second.

Worksheet #1
WIX	  51515	   4.37	   6.49	   '01-57 CHR/FORD/MAZDA'
WIX	  51516	   4.37	   6.49	   '15-81 FORD/CHR/MAZ'

Worksheet #2
W51515  	WIX	   51515
W51516	    WIX	   51516

I need to populate a field in Worksheet#1 with the first column in Worksheet#2; if WS1.a?=WS2.b? AND WS1.b?=WS2.c?.
Below is the result I would like, with the first column on Worksheet #2 inserted into Worksheet #1.

Worksheet #1 (finished product)
WIX	  51515	   4.37	   6.49	   '01-57 CHR/FORD/MAZDA'      W51515
WIX	  51516	   4.37	   6.49	   '15-81 FORD/CHR/MAZ'        W51516

[Lupp]

Your wording sounds database. Using spreadsheets there are no tables, no fields, no joins - and no queries. . There are sheets, columns, rows, cells, cell ranges - and formulas returning their results to cells they are contained in. Nothing gets “populated”.
To get something similar to a join (what kind of?) by formulas may be complicated, error-prone, and inefficient.
Only if your “?” question marks are meaning “the same row” things are simple. Otherwise there is need of better information.

[rautamiekka]

@Lupp Not fully true. The difference between a db and a spreadsheet is merely the naming: the spreadsheet file is the db, the sheets/tabs the tables and the columns and rows in the sheets are same in a typical row-based relational db.

[librebel]

Hello returnerjr, for the new column you could define a formula like this:

=IF(AND(A1 = Sheet2.B1; B1 = Sheet2.C1);Sheet2.A1;)