View the step-by-step solution to:

TOPIC: Vlookup, Hlookup vlookup: vertical lookup hlookup: horizontal lookup match: match a lookup value to an array anchors: the F4 key (fixed,...

Excel Questions (Lookups, Vlookups, Hlookups)
TOPIC: Vlookup, Hlookup vlookup: vertical lookup hlookup: horizontal lookup Q4 Range Lookup match: match a lookup value to an array anchors: the F4 key (fixed, column, row) TECHNOLOGY COSTS Provisioning Events fixed: $D$7:$M$18 Customer Apr May Jun Jul Aug Sep Oct Nov Dec Low High Water LEVEL column: $D7:$M18 ridian $2 $8,625 $8,625 $1 $8,625 $3 $8,625 $8,625 $8,625 0 100 Water 1 row: D$7:M$18 vesco $3 $3,555 $3,555 $3,555 $3,555 $3,555 $3,555 $3,555 $3,555 101 120 Water 2 Range Lookup rant $1,249 $1,249 $1,249 $1,249 $1,249 $1,249 $1,249 $1,249 $1,249 121 200 Water 3 iferror(formula,"error note") mons $770 $770 $770 $890 $900 $910 $920 $980 $1,000 201 350 Water 4 tive $39 $39 $39 $39 $39 $39 $39 $39 $39 351 Water 5 FDF $347 $347 $347 $347 $347 $390 $347 $347 $347 DAB $614 $614 $614 $614 $614 $614 $614 $614 $614 # EVENTSwater lynuvus $- $- $4,681 $4,681 $4,681 $4,681 $4,681 $4,681 $4,681 175 <enter formula here> TSSA $3,360 $3,360 $3,360 $3,360 $3,360 $3,360 $3,360 $3,360 $3,360 Mransfield $6,080 $3,040 $3,040 $3,040 $3,040 $3,040 $3,040 $3,040 TOTAL $6,383 $24,638 $26,279 $17,775 $26,409 $17,839 $26,429 $26,489 $26,509 Q1 Use lookups to populate the table below, using the table above Q2 Use lookups to populate the table below, using the table above, using the match function hint: set your anchors (F4) Customer Jun Jul Aug Sep Oct Customer Jun Jul Aug ridian ridian vesco vesco rant rant Q3 Use hlookups to populate the table below, using the table above Customer Jun Jul Aug TOTAL <-- add formula to determine the Water level for 175 events using a Range Lookup
Background image of page 1
Sign up to view the entire interaction

Top Answer

Let me explain the... View the full answer

excel problems_lookups.xls

TOPIC: Vlookup, Hlookup
vlookup: vertical lookup
hlookup: horizontal lookup
match: match a lookup value to an array
anchors: the F4 key (fixed, column, row)
fixed: $D$7:$M$18
column: $D7:$M18
row:...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online