you can use a vlookup where you have another formula in X1 but the value location in X1 is where in a vlookup formula that you are telling the formula how far to go. So if you are referencing A1:B6 you would typically see either a 2 in X1 or a 2 where X1 is in your formula. If you have true or false or 4x6 in X1 that will not tell the formula how far over to go to find the value in the lookup referenced A1:B6. Does that make sense?