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 to Expert-Tailored 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

Entrepreneurial Finance

Authors: J. Chris Leach, Ronald W. Melicher

6th edition

1305968352, 978-1337635653, 978-1305968356

More Books

Students also viewed these Finance questions