Using VLookup when the Lookup Value cell contains a formula

[davidshears]

Dear Experts - please help me...

I am running a VLookup and it works fine with manually inputted text/numbers in the lookup cell. However, the cell I am looking up itself contains a formula, shown below -

=DATEDIF(D6,NOW(),"y")&"y "

In the example I am working on, the result is 11y, but the VLookup formula then just spits out #n/a. If I type 11y into the VLookup cell, all is fine.

Any suggestions please? I've been working on this for hours!

[Tony Valko]

=DATEDIF(D6,NOW(),"y")&"y "

You have an extra space character in there.

Try this:

=DATEDIF(D6,NOW(),"y")&"y"

[davidshears]

Thank you Tony! So simple.

[Tony Valko]

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.