I have fruits. vegetables, meat, poultry and seafood. I already have a drop-down for that in the cell B8. Now I need to select a product based on the category. I tried Index and Match before but I get an error. I don't want to do it with named ranges so it has to be the formula. Hopefully, you can help.
Why don't you want to use named ranges?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
What do you have against named ranges?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I would rather use formula. I realize that I might need to use Offset but I am not sure how to use it properly.
You still haven't explained what you have against using named ranges?
Why would you "rather use formulas"?
I've posted solutions to several of your questions in the past and you never replied or responded.
You were asked to update your Excel version since xlsx is not an Excel 2003 file type, but you haven't. If you won't let us know if we've helped you, why should we
Ben Van Johnson
@ Ben, thanks.
Olga Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile says 2003, but your file indicates at least 2007
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks