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?
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?