Compare values and place corresponding value in another sheet

[Whitney]

Need help!!
Trying to search for value on one sheet and then place a value in another
column in another worksheet.
Example data:
Sheet 1
A B C D E
123 678 9876 6545 7898
456 ABD the 652 man

Sheet 2
A B
9876 123

Example - I would be searching for A2, 9876 on Sheet 1 and it would place
123 in cell B2 on Sheet 2.
Thanks for any assistance.

 

[Sheeloo]

Can you move Col C before Col A? If yes then after moving use this formula in
B1 of sheet2
=VLOOKUP(A1,Sheet1!A:B,2,False)

Assuming that after moving your earlier Col C is Col A and earlier Col A is
Col B on sheet1...

 

[Whitney]

I can't rearrance the columns. I need to look at columns B, C and D to find
the value.
Does that make sense.

 

[Sheeloo]

Then you need to have a copy of Col A to the right of your Col C... say Col Y
(you may hide it if you want) then use
=VLOOKUP(A1,Sheet1!C:Y,23,False)