Question: Enter the Zip Code 8 0 0 0 2 to use as your test Zip Code while you develop this order form. Use the VLOOKUP

Enter the Zip Code 80002 to use as your test Zip Code while you develop this order
form. Use the VLOOKUP function in cells C6, C7, C8, and C9 as follows:
a) In cell C6, create a lookup function to display the Pool Name.
b) In cell C7, create a lookup function to display the Family swimming pass price.
c) In cell C8, create a lookup function to display the Adult swimming pass price.
d) In cell C9, create a lookup function to display the Child swimming pass price.
(Note: Pool information is displayed in the Poolinfo table in the Task3-Table
 Enter the Zip Code 80002 to use as your test Zip

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!