Hi all,
I have data follows:
Product 1 10
Product 2 15
Product 3 5
Product 1 25
Product 2 40
Product 3 20
If I selection Product 1 then I should get:
10
25
If Product 2 selected then
15
40
Hope makes sense.
Regards,
Vikas
Hi all,
I have data follows:
Product 1 10
Product 2 15
Product 3 5
Product 1 25
Product 2 40
Product 3 20
If I selection Product 1 then I should get:
10
25
If Product 2 selected then
15
40
Hope makes sense.
Regards,
Vikas
hi there. like this maybe. ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks