Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do you use vlookup formula to find answers in F9 and in F18 A B D E P G H VLOOKUP 5 Name Phone

image text in transcribed

How do you use vlookup formula to find answers in F9 and in F18

image text in transcribed
A B D E P G H VLOOKUP 5 Name Phone Zip 6 Mike 704-222-4444 28110 7 Joe 704-111-5555 28277 Look Up - One 8 Jane 704-333-7777 28105 Name Phone Zip 9 Tammy 704-777-6666 28211 10 Dale 704-444-9999 28250 11 In Lookup One reate fromulas that when you type a name in F9 12 it will look up the phone and zip code and display them in G9 and H9 13 14 Quantity Price 15 10 3.99 16 20 3.49 Look Up - Two to to to to to 2.99 Quantity Price 40 2.49 19 50 1.99 20 In Lookup Two create formulas that when you type a name in F18 21 it will look up the price in G18. Make sure the number format is the 22 same as the one in the table. 23 24

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft Excel Data Analysis And Business Modeling

Authors: Wayne Winston

7th Edition

0137613660, 9780137613663

Students also viewed these Finance questions