I am trying to put together a vlookup that works on 2 criteria matching before returning the result, I have been playing around with some of the logical functions but no luck as yet.
Here is an example of what I am trying to do
You have a table of values:
a--4--mick
g--7--john
k--6--fred
a--9--peter
h--0--tom
k--2--paul
You want the vlookup to return the name where the first column = a and the second column =9, in this case the answer would be Peter.
Any ideas?
Here is an example of what I am trying to do
You have a table of values:
a--4--mick
g--7--john
k--6--fred
a--9--peter
h--0--tom
k--2--paul
You want the vlookup to return the name where the first column = a and the second column =9, in this case the answer would be Peter.
Any ideas?