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


New Member
Jun 24, 2013
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!
491114 682.3233 180.4812 366.1135 496.69
Oranges531.411 987.39621.281 897.52
Lemons1 804.822 680.034 315.13169.72
Pears10 374.1826 257.506 362.3330 269.34
Beverage1 414.952 255.56897.432 773.08



New Member
Jun 24, 2013
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

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...