Finding all instances of an ink color
I am ordering printing inks for my company. I am trying to set up a form that will lookup all the same colors. For instance we might have 4 different 185C red inks for different substrates and each of the colors could come from different vendors. This would give me up to 12 different 185C reds on my ink list. What I would like is a form that would pull up each of the 12 different 185C's and its related info. (Formula number, vendor, and price). I have tried vlookup but it only finds the first instance of 185C red. Does anyone have any other ideas?? Thanks in advance. -- ldd ------------------------------------------------------------------------ ldd's Profile: http://www.excelforum.com/member.php...o&userid=19157 View this thread: http://www.excelforum.com/showthread...hreadid=472788 |
The simplest approach (involving no programming at all) is to use autofilter.
Pull down: Data Filter Autofilter You can now select 185C and see all the records for that color. You can do the same for any other color number. Have a good day -- Gary''s Student "ldd" wrote: I am ordering printing inks for my company. I am trying to set up a form that will lookup all the same colors. For instance we might have 4 different 185C red inks for different substrates and each of the colors could come from different vendors. This would give me up to 12 different 185C reds on my ink list. What I would like is a form that would pull up each of the 12 different 185C's and its related info. (Formula number, vendor, and price). I have tried vlookup but it only finds the first instance of 185C red. Does anyone have any other ideas?? Thanks in advance. -- ldd ------------------------------------------------------------------------ ldd's Profile: http://www.excelforum.com/member.php...o&userid=19157 View this thread: http://www.excelforum.com/showthread...hreadid=472788 |
All times are GMT +1. The time now is 06:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com