vlookup match with records and inserting more records

Hi,

am having two data files, need to match with sheet data1 colum B with sheet data2 colum A and the data2 having multiple records, it as to insert into matched records data1 one by one. example i have given format at third sheet.

am attached the sample file

Please give some solution to do.

regards
Josh

Hi,

Try this formula (untested, as I'm not at my computer at the moment):

Formula:

Please Login or Register  to view this content.

or for a more generic formula (without hard-coding worksheet names in):

Formula:

Please Login or Register  to view this content.

Let me know if this works, and if not I will test my formula(s) next time I am at my computer.

Hope this helps

Hi,
thanks for your immediate replay,
Please try with my sample file at your system and send me the file,
the above formula is give some error.

regards
Josh

Sorry, I've just tested the second formula and it is rubbish, it didn't work. But there should be no problems with the first formula...

Aha! I knew I was close though...

Try this formula instead:

Formula:

Please Login or Register  to view this content.

Hope this works for you

Hi
Please match with sheet data1 of colum b with sheet data2 of colum A, then matched records should insert one by one for multiple records.

Please check the sample format

Thanks
Regards

The third sheet is manually made for sample, i want to match data1 with data2, using vlookup or other formula the result as to come like 3rd sheet .

Thanks and regards
Josh

Hi
Please match with sheet data1 of colum b with sheet data2 of colum A, then matched records should insert one by one for multiple records.

The third sheet is manually made for sample, using vlookup or other formula the result as to come like 3rd sheet .

Please check the sample format

Thanks
Regards

Hi,
Thanks very much, you have given me the correct format of out put file, so, you have Understood my requirement,i have only two files
ie. data1 and data2, ok i want the data2 file records as to insert into data1 file, which is matched with web address.


am attached sample file.


Note:I have match huge records. so, please help me to do.

thanks once again.

Regards
Josh

hi,
The data2 records as come in data1 sheet. (example if 1st record of data1 (Colum B) match with 1st record of data2 (Colum A) the web address and email as to come one by one in the data1 sheet. - (like vlookup concept and if more records(email) for same web address it as to come next row with company name. )

Aqua Turf International, Inc www.aquaturfintl.com [email protected]
Aqua Turf International, Inc www.aquaturfintl.com [email protected]
Aqua Turf International, Inc www.aquaturfintl.com [email protected]
Aqua Turf International, Inc www.aquaturfintl.com [email protected]

Thanks
Josh

Hi,
any one can help Me.

regards
Josh

Originally Posted by perusjosh

Hi,
Thanks very much, you have given me the correct format of out put file, so, you have Understood my requirement,i have only two files
ie. data1 and data2, ok i want the data2 file records as to insert into data1 file, which is matched with web address.


am attached sample file.


Note:I have match huge records. so, please help me to do.

thanks once again.

Regards
Josh

Hi

please help me to do this.


regards
Josh