User not logged in - login - register
Home Calendar Books School Tool Photo Gallery Message Boards Users Statistics Advertise Site Info
go to bottom | |
 Message Boards » » Excel question Page [1]  
45790 Posts
user info
edit post

I need to lookup values in a table by matching three criteria. The first column has duplicate row entries, the second column has unique entries per for each of COL A's values, the third column is what I need to return.

So I need to return Col C for each permutation from Col A and Col B (A,X; A,Y; AZ;..;C,X;C,Y;C,Z). I'm familiar with using INDEX, and I imagine this needs an OFFSET, but I'm less familiar with using that function. Or maybe a nested INDEX will work

Col A Col B Col C
A X 1
A Y 5
A Z 10
B X 3
B Y 4
B Z 7
C X 4
C Y 9
C Z 11

[Edited on December 10, 2015 at 11:11 AM. Reason : /]

[Edited on December 10, 2015 at 11:14 AM. Reason : .]

12/10/2015 11:11:02 AM

All American
6783 Posts
user info
edit post

Why not just concatenate Col A and B and do a VLOOKUP?

12/10/2015 11:39:48 AM

45790 Posts
user info
edit post

I can do that, but It's a bit of a pain since I'm dealing with lots of separate data sets/spreadsheets.

12/10/2015 11:48:09 AM

 Message Boards » Tech Talk » Excel question Page [1]  
go to top | |
Admin Options : move topic | lock topic

© 2020 by The Wolf Web - All Rights Reserved.
The material located at this site is not endorsed, sponsored or provided by or on behalf of North Carolina State University.
Powered by CrazyWeb v2.37 - our disclaimer.