how do i link data from one sheet to another if value keep changin

M

michellebabe

I have 2 worksheets called sheet1 and sheet2. i have 2 columns called Order #
and Division. Now i want to setup sheet2 so that it shows the same value as
what Order# and Division has in sheet1. But what if there are 2 or more
instances of Order# per one Division?
Let me demonstrate:
Sheet1 holds this info ( assuming the heading Order # is in cell A1 and
Division in cell B1 and so on...):
Order# Division
123 ABC
456 ABC
789 DEF
789 EFG

How should i code my formulas? thatnks for all the help
 

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

does anyone know how to group post? 11
Pull Data from one sheet to another 1
Using one sheet to complete information in another sheet 3
How to do more then one vlookup? 3
How to check a condition and write another cell 0
How do I link data in 1 cell on 1 worksheet (WS) to another WS 0
Transfer entire row to another sheet 2
sorting data from one sheet to another 4

Top