akhilkg1987
New Member
- Joined
- Feb 4, 2016
- Messages
- 1
Hi Excelians,
I am sorry for being a total noob.
I wish to look up values from a datasheet (daily report) into a workbook (template).My problem is I need to pick up values based on 2 columns
I tried an array formula but it didnt work when I closed my template and replaced the daily report. I dont want to concatenate and vlookup because I have to run this report several times and I wish it picks up values automatically from a different workbook (dailyreport) automatically like vlookup does.
Here is a representation
<tbody>
</tbody>
Thanks
Akhil
I am sorry for being a total noob.
I wish to look up values from a datasheet (daily report) into a workbook (template).My problem is I need to pick up values based on 2 columns
I tried an array formula but it didnt work when I closed my template and replaced the daily report. I dont want to concatenate and vlookup because I have to run this report several times and I wish it picks up values automatically from a different workbook (dailyreport) automatically like vlookup does.
Here is a representation
Col 1 | Col2 | Value1 | Value2 |
Tesco | Orange | 10 | 20 |
Tesco | Mango | 10 | 30 |
Tesco | Grape | 7 | -22 |
Walmart | Mango | 1 | 12 |
Walmart | Papaya | 3 | 0 |
Walmart | Pineapple | 30 | 23 |
SuperBuy | Mango | 3 | 11 |
SuperBuy | Orange | 1 | 0 |
SuperBuy | Kiwi | 11 | 1000 |
<tbody>
</tbody>
Thanks
Akhil