Is it possible for me to use a Vlookup in a cell in combination with a drop down list. The purpose would be to allow changing the Vlookup answer by selecting from the list.
If it is possible to do so, please provide me with instructions.
I already know how to create vlookup formulas and drop down lists, I just do not know how to combine them, because when I try to add the formula to the cell, I get the message that it does not meet the validation criteria. Thank you for any help.
If it is possible to do so, please provide me with instructions.
I already know how to create vlookup formulas and drop down lists, I just do not know how to combine them, because when I try to add the formula to the cell, I get the message that it does not meet the validation criteria. Thank you for any help.