|First, unrelated to your goal, the construction of your VLOOKUP's are wrong.|
Your table_array of A1:B1000 is 2 columns wide, yet you asking VLOOKUP to return a value from column 3 of the array. Even if the AND method you are trying would work (which it won't) the VLOOKUPS will fail with a #REF error.
Your VLOOKUP should look like this, since a lookup_array of A1:C1000 is 3 columns wide.
=VLOOKUP(A1,WK2!$A$1:$C$1000,3,0) since FALSE and 0 are the same thing to Excel.
OK, so back to your problem...
One possible method is to use a helper column in WK2 and use that for the VLOOKUP.
Let's say you have this in WK2:
A B C
1 Tom X 4
2 Bill Y 7
3 Sue X 9
Insert a new Column A and drag this formula down:
=B1 & C1
A B C D
1 TomX Tom X 4
2 BillY Bill Y 7
3 SueX Sue X 9
Now hide Column A if you want.
For your VLOOKUP in WK1, use:
=VLOOKUP(A1&"X", WK1!$A1:D3, 4, 0)
This will use the values in Column A concatenated with an X (or Y) and look them up in Column A of WK2 (TomX, BillY, etc.) and then return the value from Column D, which will be your old Column C.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.