Excel- Function Help. Lookup value on 1 sheet and post adjacent c.

[Guest]

Hello. I am needing some help with creating a function. I will try to paint
the scenario.

I have two worksheets (Sheet A) & (Sheet B).
Sheet A contains a list of item numbers in Column A and Column B & C contain
applicable information to the part number in Column A.
Sheet B contains a list of part numbers in Column A.
I'm needing to compare the list in Sheet B, Column A to the list in Sheet A,
Column A and if there is a match between Sheet A&B Column A, I need for the
values listed in Column B&C from Sheet A to populate the cells of B&C <b>Next
to the applicable, matching part number in Column A.</b> I hope I have
painted a clear picture. Any help would be appreciated!!!

 

[Frank Kabel]

Hi
try in B1 on your second sheet:
=VLOOKUP(A1,'sheet1'!$A$1:$C$100,2,0)
and in C1:
=VLOOKUP(A1,'sheet1'!$A$1:$C$100,3,0)

copy both formulas down as far as needed

 

[Guest]

Vielen Dank! I really appreciate it!!!

Hi
try in B1 on your second sheet:
=VLOOKUP(A1,'sheet1'!$A$1:$C$100,2,0)
and in C1:
=VLOOKUP(A1,'sheet1'!$A$1:$C$100,3,0)

copy both formulas down as far as needed

 

[Guest]

Hello...I have a follow-up question. The information you provided was
wonderful. What I am trying to do now is convert the information on Sheet B
to a text only or essentially capture a seperate snapshot of the information
by itself (i.e. breaking the link to the other Sheet but retaining the
information where it is).

Could you please help me acheive that result? Any help is again appreciated!!