I am looking for an excel expert to create an excel file with multiple look up formula.
- purpose is to generate a consolidated report from 4 different excel files.
Look up values - 7 columns in a raw ($A$1, $B$1, $C$1, $D$1, $E$1, $F$1, $G$1)
Column indux number - 7 raws
Range look up - Exactly matching
Output 1 - Sum of lookup values
Output 2 - latest date
I look forward to hearing from you.
79 freelancer bu iş için ortalamada 23$ teklif veriyor
I am familiar with Excel formulas and have written many macros in Excel. I can generate the report as per your requirements Relevant Skills and Experience Excel VBA Proposed Milestones $15 USD - Entire Task