• 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.

Search with list box

A

ammo4814

New Member
Hi ,

i need some help regarding the attached excel sheet , the idea i have list box include procut names and each product has a spesific number . i want to make a search tab connected with the list box .
actully i tried to use v-lookup to solve this problem but the formula dissapear once i change the scroll .

could you please give me any ideas .

Thanks
 

Attachments

  • Test.xls.xlsx
    12.6 KB · Views: 3
Hi - if I understand you correct try the below in cell C4

INDEX($M$3:$M$7,L2)
 
Last edited:
You must log in or register to reply here.
Back
Top