×

### Let's log you in.

or

Don't have a StudySoup account? Create one here!

×

or

1 review
by: clddy

42

1

1

# excel function case

Marketplace > Ohio State University > excel function case
clddy
OSU

No professor available

These notes were just uploaded, and will be ready to view shortly.

Either way, we'll remind you when they're ready :)

Get a free preview of these Notes, just enter your email below.

×
Unlock Preview

COURSE
PROF.
No professor available
TYPE
Class Notes
PAGES
1
WORDS
KARMA
25 ?

## 1

1 review
"Better than the professor's notes. I could actually understand what the heck was going on. Will be back for help in this class."

## Popular in Department

This 1 page Class Notes was uploaded by clddy on Friday March 27, 2015. The Class Notes belongs to a course at Ohio State University taught by a professor in Fall. Since its upload, it has received 42 views.

×

## Reviews for excel function case

Better than the professor's notes. I could actually understand what the heck was going on. Will be back for help in this class.

×

×

### What is Karma?

#### You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!

Date Created: 03/27/15
Three different methods can be used to lookup the data into the blank table Details as well as explanations are listed below All formulates can also be found in the excel attachment with Worksheet1 is for VLOOKUP function WorksheetZ is for INDEX function Worksheet3 is for SUMPRODUCT function The VLOOKUP Function By using the VLOOKUP function a new column was added highlighted in yellow in Data The INDEX Function By using Index function there is no need to add a helper column A MATCH function is used within the INDEX function for this method though The SUMPRIDUCT Function By using the SUMPRIDUCT function neither additional column nor additional function is needed In this way Recommendation For this case my recommendation is to use the SUMPRIDUCT function among these three methods in order to reduce errors and time Type Decilsx Marge Pulup Pkg Wt TWN SGP THA CHMMAC KOR HKG 162C 235 18200 TU 1000 04 93 06 1628 78 1U361 TU 600 98 22 08 48 20 162C 22 1U017 TU 450 46 336 40 352 82 101 162C 310 1U532 TU 1100 19 28 08 52 162C 470 1P608 TU 1100 205 162C 44 1U135 TU 525 54 162C 235 1U437 TU 1000 100 32 06 24 1628 44 1U151 TU 600 05 267 99 45 22 1628 44 1U151 8M 0 12 32 07 162C 940 18401 TU 1000 176 47 538 101 162C 78 1U335 TU 600 04 162C 78 1U336 TU 600 68 10 162C 78 1U347 TU 500 29 162C 78 1U348 TU 600 98 270 19 60 99 162C 117 1U433 TU 550 45 07 14 162C 156 18150 TU 1000 173 162C 310 18901 TU 1100 12 162C 22 1U018 TU 250 83 71 162C 33 1U032 TU 600 13 06 16 83 50 162C 156 1U434 TU 1100 81 33 98 162C 156 1U430 TU 1000 04 07 21 01 162C 44 1U136 TU 600 15 712 79 121 76 133 162C 78 18106 TU 525 338 162C 310 1U531 TU 1100 431 08 16 162C 156 1U434 8M 0 08 162C 1240 18451 TU 1000 101 32 160 00 101 1698 33 1U054 TU 600 48 137 80 10

×

×

### BOOM! Enjoy Your Free Notes!

×

Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'

## Why people love StudySoup

Steve Martinelli UC Los Angeles

#### "There's no way I would have passed my Organic Chemistry class this semester without the notes and study guides I got from StudySoup."

Janice Dongeun University of Washington

#### "I used the money I made selling my notes & study guides to pay for spring break in Olympia, Washington...which was Sweet!"

Steve Martinelli UC Los Angeles

Forbes

#### "Their 'Elite Notetakers' are making over \$1,200/month in sales by creating high quality content that helps their classmates in a time of need."

Become an Elite Notetaker and start selling your notes online!
×

### Refund Policy

#### STUDYSOUP CANCELLATION POLICY

All subscriptions to StudySoup are paid in full at the time of subscribing. To change your credit card information or to cancel your subscription, go to "Edit Settings". All credit card information will be available there. If you should decide to cancel your subscription, it will continue to be valid until the next payment period, as all payments for the current period were made in advance. For special circumstances, please email support@studysoup.com

#### STUDYSOUP REFUND POLICY

StudySoup has more than 1 million course-specific study resources to help students study smarter. If you’re having trouble finding what you’re looking for, our customer support team can help you find what you need! Feel free to contact them here: support@studysoup.com

Recurring Subscriptions: If you have canceled your recurring subscription on the day of renewal and have not downloaded any documents, you may request a refund by submitting an email to support@studysoup.com