|Before posting example data in this forum, please click on the last line of this post and read the instructions on how to format the data so that it is easier for us to read. Thanks.|
As far as your question, you can create a Helper Column with the concatenation of Position and Pref values and then do your VLOOKUP on the Helper Column.
A B C D
1 Helper Position Pref Result
2 =B2&C2 A P 1
3 =B3&C3 A Q 2
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03