vlookup/substitute cell values on multiple cell criteria

ladyredbull115

New Member
Joined
Nov 29, 2016
Messages
9
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.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
6,190
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Nov 29, 2016
Messages
9
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).
 

Watch MrExcel Video

Forum statistics

Threads
1,130,045
Messages
5,639,746
Members
417,108
Latest member
Thein Than

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top