Excel formula help: Need one-to-many vlookup type of formula

$10-30 USD

Imekamilika

Imechapishwa

over 8 years ago

$10-30 USD

Kulipwa wakati wa kufikishwa

I have a spreadsheet attached that contains an example of how the formula I need would work. Columns H & I have the table data. Columns A & H are what I want to match on. Based on an exact match between data in Columns A and H, I'd like help finding a formula that will output Columns B through F. The challenge is that one value in Column A could have many matches in Column H. I would prefer a formula and not VB code. If this requires an array formula, please specify in the deliverable instructions for how I can duplicate what you did. E.g., "Step 1: Enter XYZ in cell ABC, Step 2: Press ctrl + shift + enter, Step 3:, etc." I'm going to sleep now and will choose a bidder in the next 8-12 hours when I wake up. I'm hoping to finish this and pay the winning bidding then as soon as I wake up. Thanks!

Excel

Kitambulisho cha mradi: 8404667

Kuhusu mradi

6 mapendekezo

Mradi wa mbali

Inatumika 9 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel inlcude make formula Vlookup :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Prameswara :)

$15 USD ndani ya siku 1

5.0

(112 hakiki)

5.6

6 wafanyakazi huru wana zabuni kwa wastani $25 USD kwa kazi hii

@abumusalilla

Dear, I solve your problem asap as per your requirement also within time and budget. Contact me. Thanks and Regards Asif

$25 USD ndani ya siku 0

5.0

(11 hakiki)

3.1

@naseefo

A proposal has not yet been provided

$25 USD ndani ya siku 0

5.0

(3 hakiki)

2.9

@charleslimnet

I am an accurate and reliable business/Accounting/finance Analyst. I am a proficient business expert with over eight years writing experience. I have experience in Business plan writing, payroll, bank reconciliation, journal entries, cash flow, income statements, budgets, work plans, and financial reporting.

$40 USD ndani ya siku 1

5.0

(3 hakiki)

2.6

@mExcel

Предложение еще не подано

$15 USD ndani ya siku 0

0.0

(0 hakiki)

0.0

@msgsachin

Hello I have 15+ years of experience of working in an international bank. I can get the vlookup done and also send you the instructions as to how you can duplicate the same in other excel sheets. If you require help i can assist you on skype or show it to you manually using team viewer. Regards Sachin Sharma

$30 USD ndani ya siku 1