Problem with VLOOKUP

[tajulit]

I use this formula for copy data into sheet1 from Sheet2

=VLOOKUPINDEX($A1,Sheet2!$A:$B,COLUMN(),FALSE)

When i use VLookup formula with small text it works fine but with a large text it doesn't work. Any Solution?

 

[HungQuoc]

Sheet2!$A:$B

add index row

 

[tajulit]

Edited:
I use this formula for copy data into sheet1 from Sheet2

=IFERROR(VLOOKUP($A1,Sheet2!$A:$E,COLUMN(),FALSE),"")

When i use VLookup formula with small text it works fine but with a large text it doesn't work. Any Solution?

Example of My text:

[TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="width: 64"]http://www.imdb.com/offsite/?page-action=offsite-finefilms&token=BCYi37qHGFuydSnewTppmgErdM_LYPXfImEn5OoJfaZ8gObcI5GB9c4BwZNrhj387LcihfYibYo9%0D%0AVOsTVwihD50i5X33C2lBONBKSshWVFJE7rP9ZelsaPWmPCLaP_DoS26nAYPnCR-Mks4zuF0pOzMm%0D%0AOuBYNoQ4T4jqMiZ2rTLg8g3uI_e_gJpOVv2qAJ58szvCinNxj0-nJU3H-X0k0MgdkZRuu-SW139x%0D%0AEDBdzIChvek%0D%0A&ref_=tt_pdt_ofs_offsite_1[/TD]
[/TR]
</tbody>[/TABLE]

 

[HungQuoc]

Because finding the entire column it is should not run
Do not download file, how you see resubmit

 

[tajulit]

bump

 

[tajulit]

Because finding the entire column it is should not run
Do not download file, how you see resubmit

Hi, It is not a link for download. It is example about my data which need to Match with VLOOkUp

 

[HungQuoc]

Hi, It is not a link for download. It is example about my data which need to Match with VLOOkUp

Sorry.
Do not understand where the error
---
This trial

=INDEX(Sheet2!$B:$E,SUMPRODUCT(MIN((Sheet2!$A:$A=$A1)*ROW(Sheet2!$A:$A))),COLUMN())