From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Retrieve prices

Retrieve prices - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Retrieve prices

“

- [Instructor] This challenge came to me recently. It was from somebody who has to gather a whole lot of data. And one of the final steps is to generate a price column based on the stores 1 through 4 data. One thing that's important to know, if more than one store carries the item, the price is always going to be the same. There's no worries about that. The challenge with this data though, look at the first item, $46 all across the board. we need a 46 in G3. But then the third item, we need to bring 32.50 over. And if there is no price, we need to populate the sale with capital UA for unavailable, and that's the result we're going to need in row 9. Okay, so slow down, think about this, be crafty. All right, pause the video, work that out, come back, and I'll show you some craftiness. Let's get crafty. Now my initial thought was to nest if statements. If Store1's price is above zero, then grab that one. Otherwise, look…

Contents