Hi all. Thanks for the help in advance.
I've struggled with this one for a while. I'm basically parsing out a registry key and putting all the information on a single row. But the number of items under a header is variable and where the specific one i'm looking for is in a variable position. So what I've been doing is doing a VLOOKUP for that value. What I'm looking for help with is to make the table array variable in size based on a cell with the number of rows for that item.
For example the lookup is two columns (C & D), and we'll say we're on row 100. The row size cell says 5 so I need the table_array to be C100:D104 (specifically =VLOOKUP("Item",C100:D104,2,FALSE). Basically, I only want to look so far down; I need the final cell (D104 in this case) to be dependent on another cell.
Again, thanks!
Bookmarks