find a value and then return the value based on another criteria

cmacnab

New Member
Joined
Jun 24, 2013
Messages
29
Hi all, hoping someone can help with this. I have a report that is not formatted to work with easily. I need to find the following (I hope this shows properly, I'm having problems inserting a table):

Cell A2 is the location number. I need a formula to return the value in cell D5 (lemons $4,315.13). I would need another to return the value in cell E6 (pears $30,269.34). I have several sets of data like this and the number of lines can vary by location. I believe there is a way to do this using a Vlookup I believe but I can't recall the correct formula.

Thank you!
LocationOpeningReceiptsClosingCost
491114 682.3233 180.4812 366.1135 496.69
Apples556.960169.93387.03
Oranges531.411 987.39621.281 897.52
Lemons1 804.822 680.034 315.13169.72
Pears10 374.1826 257.506 362.3330 269.34
Plums0000
Beverage1 414.952 255.56897.432 773.08

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

cmacnab

New Member
Joined
Jun 24, 2013
Messages
29
I would be looking for either the closing or receipts total (2 different formulas but the answer should be the same for both) for a particular item; i.e. closing value for pears or receipts for lemons. It seems like it needs to be some type of double look-up.
 

Forum statistics

Threads
1,089,196
Messages
5,406,756
Members
403,105
Latest member
gituncar

This Week's Hot Topics

Top