Question: how would you produce a value in excel by having to do a lookup from one table and also another? for example: my headers on

how would you produce a value in excel by having to do a lookup from one table and also another? for example: my headers on my table are new england region, central antlantic, etc. and i have a worksheet that has the correlating codes for each region. i also have dates in the leftmost column of my table, which is on a separate worksheet table that has those dates and also the region code. i need to produce the price based on the date and the region code. how would i do that?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Winners Circle, Inc. manufactures medals for winners of athletic events and other contests. Its manufacturing plant has the capacity to produce 10,000 medals each month. Current monthly production is...

I need the solution forexsercise 33 - 38 on chapter 9of corporate financeas the attached file. pls do and send to my e..8@gmail.com Chapter 9 Stock Valuation 299 9. Corporate Ethics Is it unfair or...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

It is frequently the case that data from two or more sources needs to be combined into a single file. Even in the best case scenario when the data comes from the same technology there can be quite a...

Could you please help me with the assignment? The instructions, marking rubric and statistics are in the folders. Thank you. ACC ACF 2400 - Semester 2, 2017 Individual Assignment 1: Building a...

Year Quarter Location CarClass Revenue NumCars 2018 Q1 Airport Economy 1011191 5650 2018 Q1 Downtown Economy 943509 5965 2017 Q4 Airport Economy 926382 5122 2016 Q3 Downtown Economy 777155 5280 2017...

Week 4 Lecture 10 We have been examining the question of equal pay for equal work for several weeks now; but have been somewhat frustrated with the equal work part. We suspect that salary varies with...

This case will use an Excel Workbook as a Tutorial Tool (with learning content incorprated into each worksheet). Within the Workbook there will be multiple worksheets that the student will need to...

1. Evaluate the often tried approach of adopting past solutions to similar problems encountered today? Is this a form of linear thinking or not? 2. Why is linear thinking dangerous? 3. Whether the...

Give Detailed Steps to solve These excel problems You are an intern in the Hennepin County Violations Bureau. The Violations Bureau handles inperson traffic violation payments and answers questions...

Amanda, a regional manager for Flairol Cosmetics, has just seen a report showing that sales in her region are trending lower than anticipated for the third quarter. Her next task is to determine the...

State the role of the pancreas in the digestion of food.

Defined contribution plan participants assume investment risk for the assets in their accounts. True False

The goal of _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ is to deliver operational and tested software at the end of every iteration. The goal of blank is to deliver operational and tested software at the...