Morning all,
Hopefully someone will be able to let me know if this is possible.
I am currently trying to create a Vlookup that has a possibility of multiple results. The cell it returns could be one of a few. Vlookup normally brings back the first result which is normally fine.
I would like a formula the would let me know if there are multiple different results but would also bring through an answer if all the possible results are the same.
Eg -
A B
1 1
2 1
1 2
1 1
1 2
If i do a vlookup on the above asking to look in column A for 1s i would like a message "multiple results" but if i was looking for 2s it would give me "1".
Hope that makes sense. I have done many searches but can not find anything like this.
Is it possible?
Hopefully someone will be able to let me know if this is possible.
I am currently trying to create a Vlookup that has a possibility of multiple results. The cell it returns could be one of a few. Vlookup normally brings back the first result which is normally fine.
I would like a formula the would let me know if there are multiple different results but would also bring through an answer if all the possible results are the same.
Eg -
A B
1 1
2 1
1 2
1 1
1 2
If i do a vlookup on the above asking to look in column A for 1s i would like a message "multiple results" but if i was looking for 2s it would give me "1".
Hope that makes sense. I have done many searches but can not find anything like this.
Is it possible?