How to Lookup in range & revert with list?
A have a data record in a sheet contaning various information i.e. Stockist name, address, contact no, Dl No. company name (contaning 20 companies), if severals stockist have same compnies, how to find the list of stockist who have that companies
Name | Add | No. | DL No. | Comp. 1 | Comp 2 | Comp 3 | Comp 4 |
Abc 12 12 l45 A1 B1 C1 D1
Def 14 25 j785 D1 A1 H1 E1
Reqquired help....
Assuming your table is in A1:H3 and the company names start in E2.
Make a list of unique company names, e.g in K2 down, list A1, B1, C1, D1, etc...
Then in L2 use formula:
this formula must be confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down the list and across as many columns as necessary to retrieve all names.
Please Login or Register to view this content.
Note: Adjust ranges to match your database without going over by much... and re-confirm with CTRL+SHIFT+ENTER before copying down and across.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks