I need help with formula

M

Mehta R G

Hi,
I am trying to find a formula that compares the data from one worksheet
to another. If the data matches I want data from another column on the second
page.

Example

WorkSheet -1 WorkSheet -2 Required
Document Item Inv No Document Item Inv No.
81200692 10 83000001 81200011 110
81200905 20 83000002 81200015 400
81200011 110 83000003 81200015 190
81200015 400 83000004 81200159 40
81200691 160 83000005 81200254 30
81200340 10 83000006 81200254 20
81200159 40 83000007 81200340 10
81200254 30 83000008 81200377 40
81200254 20 83000009 81200377 10
81200015 190 83000010 81200691 160
81203085 60 83000011 81200692 10
81203981 10 83000012 81200905 20
81200377 40 83000013 81203085 60
81200377 10 83000014 81203981 10

Please give example.

Thanks for any help

Best Regards

Mehta R G
 
M

Mike H

Hi,

Try this in C1 and drag down as required

=VLOOKUP(A1,Sheet1!A$1:C$5,3,FALSE)

Mike
 

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

multiple data sheet piovt table 0
match formula needed 2
Add total items in from another worksheet? 0
re done Match formula needed 3
Average problem 1
Multiple If statements, Calculating quarterly % holding costs 0
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Finding and copying whole rows 1

Top