vlookup/substitute cell values on multiple cell criteria

[ladyredbull115]

I have a massive Access DB that I run several queries out of and paste into an Excel summary page for sharing daily. I am looking into automating it a bit further because my data can be very volatile...for example yesterday, I had a query that returned the following data:

uploading images

but today the query doesn't have any information for Pilot and Unknown, or Wave 7 and 4.0.439, etc.

image upload no size limit

Copying and pasting is too cumbersome as I have about 15 tables that I update daily and often make errors in getting the right information in the right place.

What I would like to do is paste the raw query data from the second photo into a new sheet and create a formula for column c in the first image that automatically pulls the data into it from the new sheet based on the Wave and Version number.

I have tried a few different things, including a substitute, replace, and vlookup but can't figure out what's wrong with the formulas. Any help is appreciated, thanks in advance.

 

[alansidman]

A simple non-VBA solution, would be to import the query into the appropriate Excel worksheet.

On the Ribbon--->Data--->GetExternalData-->FromAccess

Then follow the wizard to find you database and particular queries to import. Quick and easy.

 

[ladyredbull115]

Thanks for the option, but getting the data into excel daily isn't an issue. I have to summarize the data in the format of the first screenshot, which is where the problem arises, using the import option only gets the data into a new sheet but wouldn't get the data into the summary table(s).