ANSWERS: 1
-
Since asking this question I worked out an answer to it!! You insert a hidden column between B and the old C (which is now renamed D). In this new C column, you put A+B (if numerical) or A&B (if text). Then you can use vlookup on this hidden column to find the value in column D that you need. You need FALSE at the end of the vlookup, though.
Copyright 2023, Wired Ivy, LLC

by 