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 |
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) |
All times are GMT +1. The time now is 01:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com