G
gregork
I am trying to come up with a formula that looks up an order number (eg
2013864) on a list on another sheet (2)and then returns all the listings
corresponding to that number eg:
Sheet 2
Order No.s Details
2013864 red
2013864 blue
2013864 green
2013865 red
2013865 green
2013864 black
Sheet 1
2013864 (this is where I enter number to be looked up)
red ( details that )
blue (correspond to)
green ( order No )
Regards
gregorK
2013864) on a list on another sheet (2)and then returns all the listings
corresponding to that number eg:
Sheet 2
Order No.s Details
2013864 red
2013864 blue
2013864 green
2013865 red
2013865 green
2013864 black
Sheet 1
2013864 (this is where I enter number to be looked up)
red ( details that )
blue (correspond to)
green ( order No )
Regards
gregorK