Hi Guys,
Wondering how I would go about the following.
Sheet 1 Column A1 Customers Column B1 Products
A2 Mickey B2 Apple
A3 Donald B3 Orange
A4 Daisey B4 Banana
Sheet 2 Column A1 Manually type in (Customers or Products)
A2 (Formula) (look up sheet2 A1 in Sheet 1 and return 1 below it)
A3 (Formula) (look up sheet2 A1 in Sheet 1 and return 2 below it)
A4 (Formula) (look up sheet2 A1 in Sheet 1 and return 3 below it)
So if I type "customer" in Sheet 2 A1 I get the list of Mickey, Donald, Daisey in A2 - A4
And if I type "product" in Sheet 2 A1 I get the list of Apple, Orange, Banana in A2 - A4
Thanks in advance
Bookmarks