Using 2 dropdowns to pull a value from another sheet - with a twist

Jadax

New Member
Joined
Jun 4, 2020
Messages
2
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Learning excel, this is probably basic for many here - but am still a newbie, could use some help with this.
I've attached my template screenshot for what I'm doing, Left table is Tab1 (columns A-E), right is in Tab2 (columns A-D).

I made data validation dropdowns in Tab1 under S and P so I can select either. I want cost to output the corresponding value for Cost for my selections from Tab2.
I used =vlookup(C2&D2,'Tab2'!C:D,2) which is fine BUT not correct all the time because even though all Sources (S1-S3) remain the same, the Processes (P1-P4) have different values for the same P (i.e. P1 is 1 and 11 for S1).

How can I make a vlookup for 2 dropdowns to pull the correct value from another sheet without having to name each process differently? Is there a more efficient way to do something like this?
 

Attachments

  • excel.jpg
    excel.jpg
    31.5 KB · Views: 12

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Hi and welcome to MrExce.

In this case.
i.e. P1 is 1 and 11 for S1

Which one do you want to show 1 or 11 or both 1, 11 or the sum of the two 12?
It is important to understand what you need, that you put the expected result for each example.

You can put examples of your sheet ranges using the XL2BB tool, see my signature.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top