Is it possible to pull in all columns when doing a VLOOKUP in Excel?

·

When doing a v lookup to pull in columns from an a different table, is it possible to pull in all columns from that table? EG - Currently I only have the option to pull in a select few (maybe half) of the total columns and add them to the new table.

✅1

5 comments

Clay Team
APP
·
·
Hey Joey! Yes, you should be able to see all columns, but quick heads up, it's not live-sync so if you added a few after it already ran then you'll need to re-run the lookup (but it's free so there shouldn't be an issue there) :D
Clay Team
APP
·
·
Let me know if you run into any issues!
Joey W.
·
·
Hi Arturo O. - Made a quick Loom video showing the issue - https://www.loom.com/share/a1473f4a44654b89885bb45094fa719b?sid=f542f529-e4f4-46d8-a768-40df740a6cda Thanks for your help 🙂
Clay Team
APP
·
·
Ah, I see what you mean now. Due to how the data is stored within enrichment/integration columns, it can't extract and pull the data in such a way.The options are to either add new columns in your original table, one for each description or value you need, or write extracting each job into a separate table so each one has its data in its own row using our Write to table integration: https://www.loom.com/share/1ca2b46aba4843138613cc1e0917de84?sid=d3580bba-251c-4b35-b8c1-afeaa31c9225
Joey W.
·
·
Perfect, thanks 🙂