View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ashoulds ashoulds is offline
external usenet poster
 
Posts: 7
Default 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