what formula can i use to find a specific value?

[dan dungan]

Hi,

I have a table like the following

A B C D E F G H
1 ON 18 19 21 30 32 40 41
2 01 08
3 03 08
4 04 08 08 08 08
5 05
6 06 10 10
7 07 08
8 08 10 10 10 10
9 10 10 12
10 11
11 12 10
11 13 12 12 12


The first row represents the column
The second row is a connector code header:
The first column represents the row number
The second column shows the Order Number (ON)
The data is the shell size.

I have a part number: A1801B10049B0803

The connector code = 18
The Order Number = 10
The shell size =10.

For another part number: A4101B04039B0803

The connector code = 41
The Order Number = 04
The shell size =08.

For another part number: A3001B04039B0803

The connector code = 30
The order number = 04
The shell size =

This is a bad part number because there is no shell size

I can parse the connector code, and order number from the
part number, but I don't know how to retrieve the data from
the table.

What formula can I use to return such results?

Thanks

Dan

 

[dan dungan]

I ended up using this formula:

=VLOOKUP(K2,table2Proprietary!A1:T53,VALUE(MATCH(G2,table2Proprietary!
A1:T1,FALSE)),FALSE)