RE: Vlookup
Hi Carol
Thank you for your question, and apologies for the delay in reply.
According to Excel Help, the lookup value needs to be a value, a reference, or a text string, so it would suggest that a lookup value can't be a formula.
I hope this helps.
Amanda