I am looking to populate two additional cells that provide information beside my vlookup column. I have attached a simple version of what I am trying to do however the drop down list will be on a different page from the data
Thanks for any help.
I am looking to populate two additional cells that provide information beside my vlookup column. I have attached a simple version of what I am trying to do however the drop down list will be on a different page from the data
Thanks for any help.
Do you want to retrieve the "w" corresponding to sink ID, and the "h" corresponding to the same id?
Hi,
It's not at all clear (at least to me) what it is you're trying to achieve.
What do YOU mean by a drop down, what values should it contain and how should it be used.
It's not clear what your Vlookup() function looks like nor where it is.
In any case this is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.
Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
richard,
perhaps this will help explain better. My list is hundreds of pieces long and will grow daily but the parameters will always be the same
Is this waht you need?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks