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: 10

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,619
Office Version
  1. 2007
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,788
Messages
5,626,890
Members
416,208
Latest member
tan21

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
Top