Welcome toVigges Developer Community-Open, Learning,Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
3.5k views
in Technique[技术] by (71.8m points)

vba - Excel function to create a complex data base look up

My data set has more than 10 columns and many rows and the second column text is the one I want the rest of the columns and a few rows must be linked to.

So basically the second columns can be considered as text and this text consist of a few components which is data in rows and columns that I want linked to the text.

So I want to type the text in a new sheet and be able to extract all of the data linked to the text in the new sheet under the same columns headers as it was in the data set.

Is this possible and what function or vba code would I need to use to achieve this. As I can’t find something similar anywhere.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

This link might be useful for you. Try to combine examples 9 and 10 for your needs:

https://best-excel-tutorial.com/58-excel-functions/79-vlookup

Alternatively please provide more details or spreadsheet with dummy data. Will try to adjust the VLOOKUP formula for your needs.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to Vigges Developer Community for programmer and developer-Open, Learning and Share
...