How can I use vlookup here?

Hello!

I attached an Excel file.

Is there a way to use the vlookup function to extract the estimated impressions, clicks and cost from the "DATA BASE" sheet to "AD GROUP STRUCTURE" sheet?

Please notice that in the "AD GRUP STRUCTURE" sheet, the formatted keywords have quotes or brackets.

Thank you!

Formulae along these lines for your Estimated Impression:

=FILTER('DATA BASE'!K2:K142,('DATA BASE'!G2:G142=[@[AD GROUP]])*('DATA BASE'!H2:H142=SUBSTITUTE([@[FORMATTED KEYWORD]],"""","")))

Just adapt ranges for the other columns.

Your thread titles aren't very good. Instead of focusing on a function that you want to use (which may not be suitable), instead summarise here what you are trying to overcome. In this case, the pertinent issue is the quotation marks around the lookup value, and that is what needs addressing in the title. I hope to see more descriptive thread titles from you in future.

FILTER: https://support.microsoft.com/en-us/...c-4877ad80c759

SUBSTITUTE: https://support.microsoft.com/en-us/...0-1e58df3bc332

Useful link: https://bettersolutions.com/excel/fu...-functions.htm

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

Thank you, you are the best moderator!

I am one of many very good moderators (although other people's mileage may vary), but I appreciate the sentiment.

@Tommy

That doesn't do the job - there's another lookup criterion to consider.