Multi Column search

O

oaktree68

New Member
Joined
Mar 24, 2009
Messages
4
Can someone give me a hand with this, I'm lost

Heres my sample data. I want to look by part number and then return the serial number. I hope this helps a bit.

Thanks
George

<table x:str="" style="border-collapse: collapse; width: 1012pt;" width="1338" border="0" cellpadding="0" cellspacing="0"><col style="width: 56pt;" span="2" width="74"> <col style="width: 60pt;" width="80"> <col style="width: 56pt;" span="15" width="74"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 56pt;" width="74" height="17">
</td> <td style="width: 56pt;" width="74">
</td> <td style="width: 60pt;" width="80">Part Number</td> <td style="width: 56pt;" width="74">
</td> <td style="width: 56pt;" width="74">
</td> <td style="width: 56pt;" width="74">
</td> <td style="width: 56pt;" width="74">
</td> <td style="width: 56pt;" width="74">
</td> <td style="width: 56pt;" width="74">
</td> <td style="width: 56pt;" width="74">
</td> <td style="width: 56pt;" width="74">
</td> <td style="width: 56pt;" width="74">
</td> <td style="width: 56pt;" width="74">
</td> <td style="width: 56pt;" width="74">
</td> <td style="width: 56pt;" width="74">
</td> <td style="width: 56pt;" width="74">
</td> <td style="width: 56pt;" width="74">
</td> <td style="width: 56pt;" width="74">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Serial #</td> <td class="xl22">TA43478.7</td> <td>ND4270462</td> <td>ND4270205</td> <td>ND4270041</td> <td>ND4270304</td> <td>ND4270308</td> <td>ND4270208</td> <td>ND4270101</td> <td>ND4270428</td> <td>ND4237431</td> <td>ND4270298</td> <td>ND4236179</td> <td>ND4270313</td> <td>ND4270110</td> <td>ND4270297</td> <td>ND4270166</td> <td>ND4270163</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl22">TA43530.7</td> <td>BK7SWY</td> <td>BK7RYF</td> <td>BK7S7P</td> <td>BK7RXY</td> <td>BK7RY2</td> <td>BK7S7D</td> <td>BK7RYT</td> <td>BK7SWM</td> <td>BK7RY7</td> <td>BK7RY6</td> <td>BK7RYG</td> <td>BK7RWU</td> <td>BK7RWJ</td> <td>BK7SX2</td> <td>BK7LKT</td> <td>BK7RXK</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl22">TA43526.3</td> <td>ND4236776</td> <td>ND4237406</td> <td>ND4270429</td> <td>ND4270357</td> <td>ND4270380</td> <td>ND4270368</td> <td>ND4270345</td> <td>ND4270372</td> <td>ND4219702</td> <td>ND4235332</td> <td>ND4270105</td> <td>ND4270394</td> <td>ND4219701</td> <td>ND4237057</td> <td>ND4236862</td> <td>ND4270353</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl22">TA43599.2</td> <td>BK7LZT</td> <td>BK7S75</td> <td>BK7RX0</td> <td>BK7RX3</td> <td>BK7RX7</td> <td>BK7RX8</td> <td>BK7RAH</td> <td>BK7S6X</td> <td>BK7KBU</td> <td>BK7KBV</td> <td>BK7M57</td> <td>BK7RXF</td> <td>BK7BMK</td> <td>BK7RW8</td> <td>BK7RA2</td> <td>BK7RAB</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl22">TA43476.2</td> <td>BK7RYL</td> <td>BK7RYB</td> <td>BK7RW5</td> <td>BK7M49</td> <td>BK7RW3</td> <td>BK7RA8</td> <td>BK7S6M</td> <td>BK7LZV</td> <td>BK7RWK</td> <td>BK7KBC</td> <td>BK7RXA</td> <td>BK7M46</td> <td>BK7S8B</td> <td>BK7RY0</td> <td>BK7LZZ</td> <td>BK7RYM</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl22">TA43505.2</td> <td>ND4270397</td> <td>ND4270277</td> <td>ND4270169</td> <td>ND4270048</td> <td>ND4270398</td> <td>ND4270393</td> <td>ND4270341</td> <td>ND4237078</td> <td>ND4270396</td> <td>ND4270278</td> <td>ND4270052</td> <td>ND4270043</td> <td>ND4270392</td> <td>ND4270358</td> <td>ND4237408</td> <td>ND4219629</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl22">TA43526.1</td> <td>ND4270381</td> <td>ND4237424</td> <td>ND4270412</td> <td>ND4237294</td> <td>ND4235657</td> <td>ND4235710</td> <td>ND4236822</td> <td>ND4235673</td> <td>ND4237274</td> <td>ND4236830</td> <td>ND4237251</td> <td>ND4237195</td> <td>ND4237132</td> <td>ND4236880</td> <td>ND4236719</td> <td>ND4270125</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl22">TA43475.1</td> <td>ND4270120</td> <td>ND4270074</td> <td>ND4270130</td> <td>ND4270114</td> <td>ND4270071</td> <td>ND4270127</td> <td>ND4270115</td> <td>ND4270075</td> <td>ND4270126</td> <td>ND4236878</td> <td>ND4270122</td> <td>ND4270146</td> <td>ND4270143</td> <td>ND4236668</td> <td>ND4270077</td> <td>ND4270116</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl22">TA43460.2</td> <td>ND4237023</td> <td>ND4237001</td> <td>ND4237384</td> <td>ND4237390</td> <td>ND4237452</td> <td>ND4237004</td> <td>ND4237380</td> <td>ND4237018</td> <td>ND4237017</td> <td>ND4237447</td> <td>ND4218988</td> <td>ND4237026</td> <td>ND4236746</td> <td>ND4237010</td> <td>ND4236842</td> <td>ND4237019</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl22">TA43390.8</td> <td>ND4270202</td> <td>ND4237436</td> <td>ND4270326</td> <td>ND4270328</td> <td>ND4270329</td> <td>ND4219483</td> <td>ND4270206</td> <td>ND4219471</td> <td>ND4270026</td> <td>ND4237437</td> <td>ND4237414</td> <td>ND4237412</td> <td>ND4270203</td> <td>ND4270434</td> <td>ND4219666</td> <td>ND4270433</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl22">TA43475.2</td> <td>ND4236984</td> <td>ND4236824</td> <td>ND4237196</td> <td>ND4236985</td> <td>ND4237140</td> <td>ND4237273</td> <td>ND4237183</td> <td>ND4270095</td> <td>ND4236866</td> <td>ND4236823</td> <td>ND4270193</td> <td>ND4236825</td> <td>ND4237046</td> <td>ND4237045</td> <td>ND4236715</td> <td>ND4237266</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl22">TA43548.8</td> <td>BK7RA1</td> <td>BK7M4K</td> <td>BK7RAN</td> <td>BK7S7H</td> <td>BK7RWE</td> <td>BK7M4W</td> <td>BK7M4R</td> <td>BK7RWZ</td> <td>BK7S6S</td> <td>BK7RXB</td> <td>BK7M4C</td> <td>BK7RW6</td> <td>BK7M4T</td> <td>BK7RWV</td> <td>BK7KBB</td> <td>BK7LZ5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl22">ta43478.3</td> <td>ND4235674</td> <td>ND4236495</td> <td>ND4236218</td> <td>ND4270421</td> <td>ND4235654</td> <td>ND4236513</td> <td>ND4235660</td> <td>ND4219766</td> <td>ND4237237</td> <td>ND4236853</td> <td>ND4236214</td> <td>ND4237257</td> <td>ND4237041</td> <td>ND4236216</td> <td>ND4236217</td> <td>ND4237246</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl22">TA43503.7</td> <td>ND4270089</td> <td>ND4270431</td> <td>ND4236732</td> <td>ND4236974</td> <td>ND4236734</td> <td>ND4236791</td> <td>ND4237402</td> <td>ND4237487</td> <td>ND4236737</td> <td>ND4236975</td> <td>ND4236739</td> <td>ND4236972</td> <td>ND4236806</td> <td>ND4236804</td> <td>ND4237343</td> <td>ND4237348</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl22">TA43597.7</td> <td>BK7RY8</td> <td>BK7RWN</td> <td>BK7RWL</td> <td>BK7RA7</td> <td>BK7RWS</td> <td>BK7RWR</td> <td>BK7RXJ</td> <td>BK7R9Y</td> <td>BK7S71</td> <td>BK7RXN</td> <td>BK7S6L</td> <td>BK7RXS</td> <td>BK7RA3</td> <td>BK7RY5</td> <td>BK7RYD</td> <td>BK7RXM</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl22">TA43597.4</td> <td>BK7S6V</td> <td>BK7SX7</td> <td>BK7SX6</td> <td>BK7SX9</td> <td>BK7S76</td> <td>BK7SWJ</td> <td>BK7SX3</td> <td>BK7SX8</td> <td>BK7SXC</td> <td>BK7SWW</td> <td>BK7SWZ</td> <td>BK7RAE</td> <td>BK7SXB</td> <td>BK7RA9</td> <td>BK7S70</td> <td>BK7SWP</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl22">TA43446.4</td> <td>ND4237334</td> <td>ND4236512</td> <td>ND4237499</td> <td>ND4236492</td> <td>ND4236514</td> <td>ND4270180</td> <td>ND4236518</td> <td>ND4236474</td> <td>ND4236794</td> <td>ND4219515</td> <td>ND4219927</td> <td>ND4237491</td> <td>ND4218571</td> <td>ND4237201</td> <td>ND4218891</td> <td>ND4219938</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl22">TA43595.3</td> <td>BK7KBZ</td> <td>BK7LZH</td> <td>BK7S77</td> <td>BK7LZ6</td> <td>BK7M4J</td> <td>BK7LZS</td> <td>BK7S72</td> <td>BK7S7B</td> <td>BK7S74</td> <td>BK7S73</td> <td>BK7KBM</td> <td>BK7S7L</td> <td>BK7SWK</td> <td>BK7S6W</td> <td>BK7KB6</td> <td>BK7S6Z</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl22">
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> <td>
</td> </tr> </tbody></table>
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Sort by date Sort by votes
oaktree68 said:
I want to be able to search BK7S7P and have it return TA43530.7
Click to expand...

This is going to be an expensive exercise...

Control+shift+enter, not just enter...
Code: 
=IF(COUNTIF($B$2:$M$19,"BK7S7P"),
   INDEX($A$2:$A$19,MIN(IF($B$2:$M$19="BK7S7P",
      ROW($B$2:$M$19)-ROW($B$2)+1))),"NA")
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Locked
  • Question
values across tables found by name
Replies
2
Views
298
Fluff
Fluff
M
  • Question
Help with FilterXML formula
Replies
0
Views
793
montex01
M
S
  • Question
How to click a link inside a table using VBA
Replies
0
Views
1K
swapnilk
S
M
  • Question
Build HTML Table based on Loop through Excel Worksheet Column / Row condition
Replies
0
Views
542
mystik5
M
2
  • Solved
A little help with looping please
2
Replies
10
Views
881
GWteB
GWteB

Forum statistics

Threads
1,203,213
Messages
6,054,196
Members
444,708
Latest member
David R__

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