• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Advance Vlookup

sriniraj kumar

New Member
Dear Friends,
Please find the attached file in which we have to Fetch data through E Column from A and B Column by using V lookup.Please help.

Thanks and Regards
SriNiraj
 

Attachments

  • test.xlsx
    17 KB · Views: 13
More than 1 matching is found.

In F2, formula copied right to G2 and all copied down :

=IFERROR(INDEX($B$2:$B$20,AGGREGATE(15,6,ROW($A$2:$A$20)-ROW($A$1)/ISNUMBER(FIND(" "&$E2&" "," "&$A$2:$A$20&" ")),COLUMNS($A:A))),"")

Regards
Bosco
 

Attachments

  • SearchingLookup.xlsx
    18.2 KB · Views: 21
Thanks Bosco, its working but can you tell me why the below formula is not working.
=VLOOKUP("*"&E2&"*",$A$1:$B$20,2,0)

=VLOOKUP("*"&E2&"*",$A$1:$B$20,2,0)

1] Using "*" wildcard for Search Lookup the searching data cannot excess 255 characters.

2] Most of your data excess the limitation (255 characters), except A13 (154 characters) of which can work only.

3] So, you can test by picking one number inside A13, to check with the VLOOKUP formula, it is OK .

Regards
Bosco
 
Last edited:
Back
Top