Hi Tricia,

With the Drawing# to look up in D1:

=VLOOKUP(D1,$A$2:$C$5,3,FALSE)

With the Part# in D2:

=VLOOKUP(D2,$B$2:$C$5,2,FALSE)

I assumed your data with a header in A2:C5


--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Tricia LeAnn" wrote in message ...
| I've read a couple of articles on how to do it, but I still don't quite
| understand. This is what I need to do:
| Drawing # Part # Tube #
| 350TT-77A 100587 TUBE 1A
| 350TT-157B 100039 TUBE 1A
| 350TT-157C 104287 TUBE 1A
| 350TT-133A 100048 TUBE 1A
|
| Here is what my spreadsheet looks like. I need to be able to find out what
| tubes drawings and parts are in. I would like to be able to search by either
| the drawing, or the part number. Could somone please tell me how to do this?
| (Keep in mind that you are explaining this to a BLONDE!! :) )
|
| --
| Have a fantastic day!
|
| Tricia LeAnn