Hello!
Does anybody know how to use multiline data and VLOOKUP together?
I.e. my source data often has multiple lines in one cell (my data are land plots and its owners - many land plots have multiple owners), and I want to use VLOOKUP and have same multiline styling/format in the vlookup-ed data as in the source data.
Any ideas?
Many thanks
Peter
Please attach a sample of how your data is structured, what defines the expected result and it's location.
Pete
Formulas cannot "copy" formatting from another cell - you would need to pre-format the cell containing the formula
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
If I'm not misunderstood, you may use * in vlookup search term.
For sample
Vlookup( "*somthing*" , range , column_number , false )
Regards.
My English is very poor, so please be patient >_<"
My Dynamic Related Dropdown post:
https://www.excelforum.com/excel-for...ml#post5657376
https://www.excelforum.com/excel-for...ml#post5655711
https://www.excelforum.com/excel-for...ml#post5655762
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks