Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what formula can i use to find a specific value?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what formula can i use to find a specific value?
I ended up using this formula:
=VLOOKUP(K2,table2Proprietary!A1:T53,VALUE(MATCH(G 2,table2Proprietary! A1:T1,FALSE)),FALSE) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to find specific a value across a row using IF(AND | Excel Worksheet Functions | |||
find value in specific row | Excel Discussion (Misc queries) | |||
Can I create a formula to find a specific value within a group of. | Excel Worksheet Functions | |||
find formula that will look up a value in a specific column and . | New Users to Excel | |||
How Do I Find A Specific Worksheet | Excel Discussion (Misc queries) |