Hi,
I am looking to do a vlookup based on 2 conditions and have no idea how to do it.
At the moment I am doing a vlookup on a cell in column A and it is producing a particular value, the problem is that this cell appears a few times in column A. So what I need to do is lookup the cell in column A but also based on the corresponding data in column B to get the correct lookup value.
For example
2109 Dave
2109 John
2108 Dave
So at the moment when I am looking up 2109 it is always producing the value corresponding to what Dave has put in, I need to know what both Dave and John have put in
I hope this made some sense, any help would be truly appreciated.
Thanks
I am looking to do a vlookup based on 2 conditions and have no idea how to do it.
At the moment I am doing a vlookup on a cell in column A and it is producing a particular value, the problem is that this cell appears a few times in column A. So what I need to do is lookup the cell in column A but also based on the corresponding data in column B to get the correct lookup value.
For example
2109 Dave
2109 John
2108 Dave
So at the moment when I am looking up 2109 it is always producing the value corresponding to what Dave has put in, I need to know what both Dave and John have put in
I hope this made some sense, any help would be truly appreciated.
Thanks