I have a huge parts sheet with thousands of rows and columns, cross-referenced to a master parts list. I attach a small sample:
<tbody>
</tbody>I want to type a ramdom part number as a search option, a)look for it across the table (in reality A2:OHT5200), get the master part number, and use that to b)retrieve the corresponding B and C cell values, and c)bring the rest of the row.
I would prefer formulas rather than VBA.
Is this possible?
Generic part | finishing | description | part 1 | part 2 | part 3 | part 4 | part 5 | part 6 | part 7 | part 8 | part 9 | part 10 |
128 | 0-008 | 73110 | 0002SC1383 | 0002SC968P | 001-012685 | 001-021110 | 001-021111 | 001-02119-0 | 001-021190 | 001-021290 | ||
128+129(CP) | 121661 | 14-602-57 | 34-6010 | |||||||||
128/400 | 25C960 | 25C960A | 2SC23 | 2SC24 | 690B | C.L0D | C23 | C24 | C960 (JAPAN) | CL.0C | ||
128/401 | 13-33742-1ME | 19-020-050 | 40409 | 40625 | 40628 | 471-1 (METAL) | 48-869561 | 742-1 (METAL)(SYL) | M9561 | |||
128/411! | 121-279 | 86-121-2 | 86-5109-2 | SC4131 | SC4131-1 | SC4167 | SC4244 | TI487 | ||||
128/427! | 6117 | 126722 | 1473567-1 | 23-5037 | 2SC960 | 2SC960-0 | 2SC960A | 2SC960B | 2SC960C | 2SC960D | ||
1283! | HA1368 | HA1368G | SK9267 | |||||||||
1284! | HA1368R | HA1368RW | SK9268 | |||||||||
1285! | 051-0183-00 | 051-0183-01 | 58R-300-86 | 68S-200-98 | 77A-211-86 | 78C-210-86 | 78E-350-124 | 916171 | 916204 | 93D-200-91 | ||
1287 | NTE1287 | |||||||||||
1287! | SK9228 | TDA2020 | TDA2020AC2 | |||||||||
128? | TI486 | |||||||||||
128P | 1198-4267 | 177471 | 1854-0997 | 1854-1064 | 186642 | 2221 | 2221A | 2222 | 2222A | 2N6716 | ||
128P? | 2N6718 | 2N6731 | 92PU05 | 92PU06 | 92PU07 | ED1702 | ED1702C | ED1702D | ED1702K | ED1702L | ||
129 | 0-008 (Ampex) | 0-009 | 62 | 001-022060 | 002-010300-6 | 002-010700 | 002-012600 | 002-9800-12 | 55 | 006-0004956 |
<tbody>
</tbody>
I would prefer formulas rather than VBA.
Is this possible?