I need to build a table with cell 1 of each column containing the server name with all the cells below it showing nodes on that server. I want to search all nodes and return the row 1 value of that column containing the node name. vlookup, hlookup, etc - all wont work - help. I could build 1 very long column with all the nodes then in column 2 put the server name repeating it every row but that seems inefficient. Multiple columns (servers) with the nodes listed in that column.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Search Table, return row 1 valu
- Thread starter Pappygt
- Start date
- Status
Excel Facts
Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
GerryZ
Well-known Member
- Joined
- Jul 4, 2014
- Messages
- 1,224
- Office Version
- 365
- Platform
- Windows
Hello!
I like this question but I don't understand all of the issue It was nice to see a spreadsheet sample instead to use 1000s of words and formula
Can you post a screenshot with just few rows and colunms with the expected outcome so we can understand better?
I suggest you to post a nice HTML screen-shot with Mr.Excel HTML Maker, if you don’t know how to istall and how to use it watch the video linked in my signature
help us to help you
Thank you in advance!
I like this question but I don't understand all of the issue It was nice to see a spreadsheet sample instead to use 1000s of words and formula
Can you post a screenshot with just few rows and colunms with the expected outcome so we can understand better?
I suggest you to post a nice HTML screen-shot with Mr.Excel HTML Maker, if you don’t know how to istall and how to use it watch the video linked in my signature
help us to help you
Thank you in advance!
starl
Administrator
- Joined
- Aug 16, 2002
- Messages
- 6,081
- Office Version
- 365
- Platform
- Windows
- Status
