Why VLookUP not work with large text

Question

I use a formula for copying data from sheet2 to sheet1 with this formula

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

It works well. But It doesn't work with large text. My text example:

http://www.imdb.com/offsite/?page-action=offsite-warnerbros&token=BCYjjcO9abopG7_2269JEn7520-r1f47KXvVIHfXH9dnHF2X3Dl07RaPqaEf8uh7ByYPH-tpY4mE%0D%0AFfjrAfF563s_sY8adxepid38SNgmJgrgRHMj5Oc0ffeB2tQe6wuVo68X5BQTu6B5uGGeMdQWKvZM%0D%0AelqFAg7XgXLNFluju2rwoseKKst4rCNtHlnnjk7a4PSCCKR6CPNEEvA45VGl1fdOJ5qThsifWItR%0D%0AefPnChuWEX4%0D%0A&ref_=tt_pdt_ofs_offsite_1

See this: http://superuser.com/questions/247427/255-character-limit-on-vlookup — John Coleman, Jun 18 '16 at 14:01

score 0 · Answer 1 · edited May 23 '17 at 12:14

0

Applying @barry's solution to what I am guessing is where and what you want, maybe:

=IFERROR(INDEX(Sheet2!B:B,MATCH(TRUE,INDEX(Sheet2!A:A=A1,0),0)),"")

edited May 23 '17 at 12:14

Community

1
1

answered Jul 22 '16 at 16:43

pnuts

58,317
11
87
139

Why VLookUP not work with large text

1 Answers1