# Vlookup on a cell with a formula

✭✭✭✭✭

Hi,

Is it not possible to use a vlookup formula on a cell that contains another formula? I tried and I get "no match".

This is the formula I tried. There is a match in my lookup table for Map ID 2. I have double checked. Thanks for any help!

• ✭✭✭✭✭✭

Yes, that should work.

Can you describe your process in more detail and maybe share the formula(s), sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭

Hi!

Does this help?

Formulas below for copy/paste if needed. Image below with a little more explanation. Thanks!

=JOIN([Outside Lots- Map ID for Zone 1]@row:[Outside Lots- Map ID for Zone 4]@row)

=VLOOKUP([Outside Lots- Map ID]@row, {Landscaping- Outside Lots Lookup Table Range 1}, 2, false)

• ✭✭✭✭✭✭

I think it has to do with using the JOIN function. Your JOIN function is basically outputting a string of "2blankblankblank", but the other sheet only has a "2". Try replacing the JOIN function with this:

=JOIN(COLLECT([Outside Lots- Map ID for Zone 1]@row:[Outside Lots- Map ID for Zone 4]@row, [Outside Lots- Map ID for Zone 1]@row:[Outside Lots- Map ID for Zone 4]@row, @cell <> ""))

Incorporating a COLLECT function and telling it to only JOIN those cells that are not blank should output "2" instead of "2blankblankblank".

• ✭✭✭✭✭

Hi!

I copied your formula in and I still get No Match

• ✭✭✭✭✭

Hi!

I copied your formula in and I still get No Match

• ✭✭✭✭✭

It worked! Thank you!!

• ✭✭✭✭✭✭

Happy to help. 👍️

• ✭✭✭✭✭✭

Happy to help!

Let me know if I can help with anything else!

Best,

Andrée

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭

Will do! Thank you both. 😀

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!