lookup value and post adjacent cells value from two wrksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I will try to decribe the problem.

I have 2 worksheets. Sheet A & Sheet B.
Sheet A contains part numbers in Column A and has related information to the
part on that same row in Column B & C.
Sheet B has a list of part numbers in Column A and empty cells on the same
row in Column B & C.

I want the program to look at the part numbers in Sheet B, Column A and
compare it to the part numbers in Sheet A, Column A and return the values in
Column B & C onto Sheet A next to the matched part number. (by the way - not
all part numbers will be there and they can be in any order for the two
Column A's).
 
Hi
you already receivend an answer to your last post (I assume you're
'Hoganlo')
 
I'm sorry (yes...hoganlo). I never received a notification in my Hotmail
e-mail Inbox and when I searched...I couldn't find my post. I thought it
hadn't posted for some reason. I will find the post and get the answer.
Thanks.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What type of "lookup" 3
VLOOKUP and IF together 3
Lookup and Display Multiple Unique values based on criteria 7
comparing two sheet of data -- cost price increases 2
Excel- Function Help. Lookup value on 1 sheet and post adjacent c. 3
Copy corresponding cell in Column B if cell in A contains certain text? 1
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
With F1 value, look at A, if match or partial match return B 5

Back
Top