I have a ss with different tabs. I'm retrieving information from another tab called Servers to populate another tab based on certain search criteria. The tab I'm collecting data from looks similar to this:
I want to be able to pull data from a given row that matches a search criteria. For instance, lets say I'm searching for boxB with the number in the macthing column that contains a 6. this means I want data from row 3.
I'm able to find the column based on a unique name (boxB) populated in M32 by using MATCH(M32,Servers!$1:$1,0). Column found = 5. Now, how do I find row number? I don't know how to tell the function to look in column 5 to find a number 6 to give me the row number.
I planned on using the row and col in the index function to retrieve the data.
How do I find the row or if there is an easier way, please let me know.
Thanks[/img]
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Host | App | OS | boxA | boxB | boxC | ||
2 | Coke | Diet | Solaris | 6 | ||||
3 | Sprite | MIS | AIX | 6 | ||||
4 | Beer | Sys | HP | 5 | ||||
5 | Grape | Micro | Solaris | 1 | ||||
Sheet1 |
I want to be able to pull data from a given row that matches a search criteria. For instance, lets say I'm searching for boxB with the number in the macthing column that contains a 6. this means I want data from row 3.
I'm able to find the column based on a unique name (boxB) populated in M32 by using MATCH(M32,Servers!$1:$1,0). Column found = 5. Now, how do I find row number? I don't know how to tell the function to look in column 5 to find a number 6 to give me the row number.
I planned on using the row and col in the index function to retrieve the data.
How do I find the row or if there is an easier way, please let me know.
Thanks[/img]