One way using index/match
With the table as posted,
Inputs in G2 down, eg: 100024
Place in H2: =INDEX(E:E,MATCH(G2,B:B,0))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tricia LeAnn" wrote:
Ok, I hate to be a pain, but I'm sure people who use excel regularly would
understand that completely, but I'm still having some trouble. I'll give you
my spreadsheet information in more detail, and maybe you can help me then.

A1- PROJECT: Quickfind Tube Index!

A3- DrAwInGs iN TUBE: 1A

(A5)DRAWING # (B5)PART # (e5)Tube #
(A6)350TT-8A & 9A (B6)104597 (E6)TUBE 1A
(A7)350TT-29A (B7)100011 (E7)TUBE 1A
(A8)350TT-33 (B8)103220 (E8)TUBE 1A
(A9)350TT- 50A (B9)100019 (E9)TUBE 1A
(A10)350TT-62 (B10)100024 (E10)TUBE 1A
What I'm trying to do is make a searchable database where I can find out
which tubes certain drawings and part numbers are located in. I have already
entered all of the information, and there are about 4,500 different
corresponding drawing and part numbers that I have in the system. I would
like to be able to just type in "100024" and find out that it is located in
TUBE 1A. Does that make more sense?

Again, I am sorry to be such a hassle, but I really do appreciate your help!
--
Have a fantastic day!

Tricia LeAnn