Search row and column

S

shrikant sinnur

New Member
Joined
Jan 29, 2009
Messages
16
a b c d e f

<table x:str="" style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" height="204" width="457"><col style="width: 41pt;" width="54"> <col style="width: 45pt;" width="60"> <col style="width: 138pt;" width="184"> <col style="width: 29pt;" width="39"> <col style="width: 41pt;" width="55"> <col style="width: 51pt;" width="68"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl25" style="height: 15pt; width: 41pt;" height="20" width="54">808WJO</td> <td class="xl26" style="border-left: medium none; width: 45pt;" width="60">4040-0002</td> <td class="xl26" style="border-left: medium none; width: 138pt;" width="184"> WAY BLOCK</td> <td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td class="xl27" style="border-left: medium none; width: 29pt;" x:num="" width="39">1</td> <td class="xl28" style="border-left: medium none; width: 41pt;" width="55">W-456</td> <td class="xl29" style="border-left: medium none; width: 51pt;" x:num="39905" width="68">4/2/2009</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl25" style="border-top: medium none; height: 15pt;" height="20">105WJO</td> <td class="xl31" style="border-top: medium none; border-left: medium none;">5945-8055
</td> <td class="xl31" style="border-top: medium none; border-left: medium none;">DRIVE BOX </td> <td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td class="xl32" style="border-top: medium none; border-left: medium none;" x:num="">2</td> <td class="xl33" style="border-left: medium none;">W-457</td> <td class="xl29" style="border-top: medium none; border-left: medium none;" x:num="39935">5/2/2009</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl25" style="border-top: medium none; height: 15pt;" height="20">808WJO</td> <td class="xl26" style="border-top: medium none; border-left: medium none; width: 45pt;" width="60">5952-8016
</td> <td class="xl26" style="border-top: medium none; border-left: medium none; width: 138pt;" x:str="PULLEY SHAFT " width="184">PULLEY
</td> <td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td class="xl34" style="border-top: medium none; border-left: medium none; width: 29pt;" x:num="" width="39">5</td> <td class="xl33" style="border-left: medium none;">W-458</td> <td class="xl30" style="border-top: medium none; border-left: medium none;">13/02/2009</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl25" style="border-top: medium none; height: 15pt;" height="20">808WJO</td> <td class="xl26" style="border-top: medium none; border-left: medium none; width: 45pt;" width="60">5942-8025</td> <td class="xl26" style="border-top: medium none; border-left: medium none; width: 138pt;" x:str="SPRING RETAINER " width="184">SPRING</td> <td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td class="xl34" style="border-top: medium none; border-left: medium none; width: 29pt;" x:num="" width="39">16</td> <td class="xl33" style="border-left: medium none;">W-458</td> <td class="xl30" style="border-top: medium none; border-left: medium none;">13/02/2009</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl25" style="border-top: medium none; height: 15pt;" height="20">808WJO</td> <td class="xl26" style="border-top: medium none; border-left: medium none; width: 45pt;" width="60">1241-0390</td> <td class="xl26" style="border-top: medium none; border-left: medium none; width: 138pt;" x:str="ROLLER BRACKET L. H. (FRONT) " width="184">ROLLER1 </td> <td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td class="xl34" style="border-top: medium none; border-left: medium none; width: 29pt;" x:num="" width="39">3</td> <td class="xl33" style="border-left: medium none;">W-458</td> <td class="xl30" style="border-top: medium none; border-left: medium none;">13/02/2009</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl25" style="border-top: medium none; height: 15pt;" height="20">808WJO</td> <td class="xl26" style="border-top: medium none; border-left: medium none; width: 45pt;" width="60">1241-0504</td> <td class="xl26" style="border-top: medium none; border-left: medium none; width: 138pt;" width="184">ROLLER2</td> <td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td class="xl34" style="border-top: medium none; border-left: medium none; width: 29pt;" x:num="" width="39">4</td> <td class="xl33" style="border-left: medium none;">W-458</td> <td class="xl30" style="border-top: medium none; border-left: medium none;">13/02/2009</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl25" style="border-top: medium none; height: 15pt;" height="20">768WJO</td> <td class="xl26" style="border-top: medium none; border-left: medium none; width: 45pt;" width="60">1241-0504</td> <td class="xl26" style="border-top: medium none; border-left: medium none; width: 138pt;" width="184">ROLLER3</td> <td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td class="xl34" style="border-top: medium none; border-left: medium none; width: 29pt;" x:num="" width="39">16</td> <td class="xl33" style="border-left: medium none;">W-459</td> <td class="xl30" style="border-top: medium none; border-left: medium none;">13/02/2009</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl25" style="border-top: medium none; height: 15pt;" height="20">1621VJO</td> <td class="xl26" style="border-top: medium none; border-left: medium none; width: 45pt;" width="60">1241-0521</td> <td class="xl26" style="border-top: medium none; border-left: medium none; width: 138pt;" x:str="ROLLER BRACKET REAR (L. H.) " width="184">ROLLER4</td> <td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td class="xl34" style="border-top: medium none; border-left: medium none; width: 29pt;" x:num="" width="39">2</td> <td class="xl33" style="border-left: medium none;">W-460</td> <td class="xl30" style="border-top: medium none; border-left: medium none;">13/02/2009</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl25" style="border-top: medium none; height: 15pt;" height="20">1621VJO</td> <td class="xl26" style="border-top: medium none; border-left: medium none; width: 45pt;" width="60">1241-0503</td> <td class="xl26" style="border-top: medium none; border-left: medium none; width: 138pt;" width="184">ROLLETR7 </td> <td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td class="xl34" style="border-top: medium none; border-left: medium none; width: 29pt;" x:num="" width="39">2</td> <td class="xl33" style="border-left: medium none;">W-460</td> <td class="xl30" style="border-top: medium none; border-left: medium none;">13/02/2009</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl25" style="border-top: medium none; height: 15pt;" height="20">1621VJO</td> <td class="xl26" style="border-top: medium none; border-left: medium none; width: 45pt;" width="60">1241-0524</td> <td class="xl26" style="border-top: medium none; border-left: medium none; width: 138pt;" x:str="ROLLER BRACKET FRONT (R. H.) " width="184">ROLLER9 </td> <td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td><td class="xl34" style="border-top: medium none; border-left: medium none; width: 29pt;" x:num="" width="39">2</td> <td class="xl33" style="border-left: medium none;">W-460</td> <td class="xl30" style="border-top: medium none; border-left: medium none;">13/02/2009</td> </tr> </tbody></table>


sir,
in other sheet using E column (like w-458) i want to get all other column and rows data (w-458 in e and 808wjo in there column are same)



thanks
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Sort by date Sort by votes
Re: surch row and column

I think that you need to use match & index functions, assuming you have the data in Col E on your new sheet e.g. =MATCH(E3,old!E3:E12,0). this will report which row of old E3:E12 the match is. Use Index to get teh other columns, e.g. =INDEX(old!A3:F12,H3,1) for Column 1 and =INDEX(old!A3:F12,H3,2) for Column 2 etc.
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
VBA for Web Scraping help
Replies
0
Views
606
epactheactor
E
A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
P
  • Question
Select the time from the list and search with Selenium VBA
Replies
6
Views
245
John_w
J
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
853
gvsumich
G

Forum statistics

Threads
1,215,459
Messages
6,124,945
Members
449,198
Latest member
MhammadishaqKhan

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top