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>
 

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,084,753
Messages
5,379,658
Members
401,620
Latest member
Ankur Teotia

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top