Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find a value in a table
I need a function that would be able to tell the difference between the size,
color and material and spit out the order code for the option that fits. Any ideas? An example of my table is below (Size, Color, Material, Order Code) 2, B, R, 1 2, B, R, 2 2, B, P, 3 2, B, P, 4 4, R, R, 5 4, B, R, 6 4, R, P, 7 4, B, P, 8 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find a value in a table
Are the commas indicators of new column or is the entire list within one cell?
Also, there are multiple with the same Size/Color/Material. Presumably, you want both order codes returned? "ashoulds" wrote: I need a function that would be able to tell the difference between the size, color and material and spit out the order code for the option that fits. Any ideas? An example of my table is below (Size, Color, Material, Order Code) 2, B, R, 1 2, B, R, 2 2, B, P, 3 2, B, P, 4 4, R, R, 5 4, B, R, 6 4, R, P, 7 4, B, P, 8 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find a value in a table
Commas indicate columns. There are 4 columns. There is only one order code
for each. "Sean Timmons" wrote: Are the commas indicators of new column or is the entire list within one cell? Also, there are multiple with the same Size/Color/Material. Presumably, you want both order codes returned? "ashoulds" wrote: I need a function that would be able to tell the difference between the size, color and material and spit out the order code for the option that fits. Any ideas? An example of my table is below (Size, Color, Material, Order Code) 2, B, R, 1 2, B, R, 2 2, B, P, 3 2, B, P, 4 4, R, R, 5 4, B, R, 6 4, R, P, 7 4, B, P, 8 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find a second value in a table with VLOOKUP | Excel Worksheet Functions | |||
pivot table - trying to find A OR B instead of A AND B | Excel Discussion (Misc queries) | |||
Find a value in the table cell | Excel Worksheet Functions | |||
Find data in one table from another. | Excel Worksheet Functions | |||
Excel - Find a value in a Table !!??!! | Excel Discussion (Misc queries) |