Vlookup Based On Two Conditions
Once again a little problem I'm not capable of solving on my own..
I need a function to look up values vertically in a separate (other) linked Excel-file based on two conditions.
The separate file is a rawdata-dump file and comes periodically in a fixed format. In my current file I try to go lookup certain values in that rawdata-file, based on two conditions:
1: in A:A a month text value (MMM) in the rawdata file
2: in B:B a one-digit year number (Y) in the rawdata file
Because this is a serial task (I've got 18 different rawdata files) I cannot solve the problem with a simple VLOOKUP combined with CONCATENATE of A and B, I would have to manually edit each rawdata file by adding a fresh row and the CONCATENATE function..
I found a nice formula how to solve this problem via the =INDIRECT function, but my problem is that INDIRECT only works with open linked workfiles. This means that I can only use my spreadsheet with the formula when the rawdata-file(s) is(are) opene(d), which I do not want to have open 18 times... (This formula you will find in the attachment!)
See attachted an example of my rawdata output and how I want to lookup the values. Just imagine that the worksheet "rawdata" is a separate excel-file on a different location.
Hope you understand...
Last edited by Davidoff; March 8th, 2007 at 00:20.
Video Tutorials / Excel Dashboards Reports