Find and reference values across multiple rows and columns

feliciano

New Member
Joined
Nov 12, 2018
Messages
1
I have a huge parts sheet with thousands of rows and columns, cross-referenced to a master parts list. I attach a small sample:
Generic partfinishingdescriptionpart 1part 2part 3part 4part 5part 6part 7part 8part 9part 10
1280-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/40025C960 25C960A 2SC23 2SC24 690B C.L0D C23 C24 C960 (JAPAN) CL.0C
128/40113-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
1287NTE1287
1287!SK9228 TDA2020 TDA2020AC2
128?TI486
128P1198-4267 177471 1854-0997 1854-1064 186642 2221 2221A 2222 2222A 2N6716
128P?2N6718 2N6731 92PU05 92PU06 92PU07 ED1702 ED1702C ED1702D ED1702K ED1702L
1290-008 (Ampex) 0-009 62 001-022060 002-010300-6 002-010700 002-012600 002-9800-12 55 006-0004956

<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?
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Forum statistics

Threads
1,213,543
Messages
6,114,240
Members
448,555
Latest member
RobertJones1986

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