Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Vlookup or Formula Help Needed

0

Hello, I need help to create a formula using multiple criteria. The output i need is "ORG REGION". My reference worksheet has Sales Order#, Product ID & ORG Region. There are thousands of lines with Sales Order# with different ORG Regions based on the Product ID. I need a formula to get me the ORG REGION by SO# AND Product ID. Hellp

Answer
Discuss

Answers

0

The simple way to do this is to create a new column that combines the SO# and Product ID column values and then perform the lookup on that new column.

If the product ID is xyz and the SO# is 10 then create a column that would have 10xyz as its value. Do this using a basic formula like this:

= B1 & C1 where B1 has the SO# and C1 has the product ID

Then, for the lookup value in your formula just make sure to type both the SO# and product ID.

Attached is a sample file that shows you how to do this.

Discuss
0

I gree with Don....you could, after you create the other NEW column, create a Pivot table to help organize your data (depending on what you are looking for)

Discuss

Discussion

If it's a solution it's an Answer. If it's a suggestion it's a Discussion. If it isn't helpful it's a waste of time.
Apart from that, I had been hoping you would weigth in on this question with a pivot based answer (a real one). Please re-read the question. It's clear enough. However, I had thought it possible to avoid creating an extra column, putting the concatenation into the specs of the pivot column. That's the part which would have made a pivot based answer superior over others.
Variatus (rep: 4889) Oct 9, '17 at 7:36 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login