Hi all
Thanks in advance for your help.
I have been trying to find something to help me make my excel spreadsheet work, nut no luck.
So here it is.
I have a list on hundreds of parts, a few columns, like part number, description, infor, and locations.
I'm interested in:
A way of quickly find in that spreadsheet, searching by (partial) description only
get the results and either jump to that row
Or
Load that row completely at the top of the spreadsheet.
So far I managed to use VLookup and Match functions to get it work, but I'm only getting the row number where my part is,
I would like it to jumpnto that row or, like ai said, load the whole row completely
Thanks in advance for your help.
I have been trying to find something to help me make my excel spreadsheet work, nut no luck.
So here it is.
I have a list on hundreds of parts, a few columns, like part number, description, infor, and locations.
I'm interested in:
A way of quickly find in that spreadsheet, searching by (partial) description only
get the results and either jump to that row
Or
Load that row completely at the top of the spreadsheet.
So far I managed to use VLookup and Match functions to get it work, but I'm only getting the row number where my part is,
I would like it to jumpnto that row or, like ai said, load the whole row completely
