I say Deadly - because after a week on and off of trying to work this out I'm still none the wiser and I have brain freeze! I'm not super slick on Excel but I thought this would be possible. In Sheet 1, I'm trying to populate Column C with the corresponding value in Sheet 2. As I write this, it sounds really simple, but I fear that it isn't.
So the logic for the value I want returned in Column C in Sheet1 1is something like If A2=Sheet2A2:A6 AND B2=Sheet2B1:B5 then return value in Sheet2 CellB2:F6
Is that possible? And if so is it Nesteds IFs or is it a more complex VLookup?
I can't simply transpose one of the sheets because the info I want is part of a much bigger sheet. The below is just a truncated simplified view for demonstration of the problem.
Any help would be MUCH appreciated!!
Cheers
RichieA
<tbody>
</tbody>
So the logic for the value I want returned in Column C in Sheet1 1is something like If A2=Sheet2A2:A6 AND B2=Sheet2B1:B5 then return value in Sheet2 CellB2:F6
Is that possible? And if so is it Nesteds IFs or is it a more complex VLookup?
I can't simply transpose one of the sheets because the info I want is part of a much bigger sheet. The below is just a truncated simplified view for demonstration of the problem.
Any help would be MUCH appreciated!!
Cheers
RichieA
Sheet 1 | |||||
Client | Office | Value | Next Action | Latest Event | |
Alpha Inc | Austria | Arrange meet | Sold 1000 units | ||
Alpha Inc | Belgium | Supply goods | Visit complete | ||
Alpha Inc | Canada | Supply goods | Visit complete | ||
Alpha Inc | Denmark | Shut down | Shut down | ||
Alpha Inc | Egypt | ||||
Bravo Inc | Austria | ||||
Bravo Inc | Belgium | ||||
Bravo Inc | Canada | Rugby | Lunch | ||
Bravo Inc | Denmark | ||||
Bravo Inc | Egypt | ||||
Sheet 2 | |||||
Austria | Belgium | Canada | Denmark | Egypt | |
Alpha Inc | 25 | 63 | 564 | 34 | 67 |
Bravo Inc | 42 | 40 | 32 | 56 | 40 |
Charlie Inc | 23 | 29 | 45 | 61 | 21 |
Delta Inc | 33 | 568 | 98 | 52 | 231 |
Echo Inc | 97 | 238 | 56 | 21 | 47 |
<tbody>
</tbody>