 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2007Hlookup help
I have a spreadsheet with 23 columns and 361 rows. I am looking to see if I can use HLOOKUP to show me the lowest price in columns G-K-P. The other columns have different data in them. Is there a way to use HLOOKUP or something else to do this? Excel 2007 Thanks in advance. Ed Are you looking for the lowest value in G,K and P for a certain item (maybe it is named in A)? We need a bit more to go on! best wishes  SignatureBernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address >I have a spreadsheet with 23 columns and 361 rows. I am looking to see if I >can use HLOOKUP to show me the lowest price in columns G-K-P. The other [quoted text clipped - 5 lines] > Thanks in advance. > Ed I'm sorry. You are correct. I want to take what is in C3 and fine the lowest value in G,K & P3. > Are you looking for the lowest value in G,K and P for a certain item > (maybe it is named in A)? [quoted text clipped - 9 lines] >> Thanks in advance. >> Ed You still have not explained very well. How about an example. SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > I'm sorry. You are correct. I want to take what is in C3 and fine the > lowest value in G,K & P3. [quoted text clipped - 12 lines] >>> Thanks in advance. >>> Ed In this particular spreadsheet I have 23C x 361R with various types of data. In column A I have an ITEM # and in columns G,K &P I have prices for 3 different manufacturers. I would like to be able to isolate the lowest price for each item without having to hide columns and manually doing it by eye. I hope this clears it up. > You still have not explained very well. How about an example. > [quoted text clipped - 14 lines] >>>> Thanks in advance. >>>> Ed Lets say the data is in A1:X361 In Z1 you type in an item number In Z2: =MIN(VLOOKUP(Z2,A1:P361,7 ),VLOOKUP(Z2,A1:P361,11 ),VLOOKUP(Z2,A1:P361,16 )) best wishes SignatureBernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email > In this particular spreadsheet I have 23C x 361R with various types of > data. In column A I have an ITEM # and in columns G,K &P I have prices for [quoted text clipped - 20 lines] >>>>> Thanks in advance. >>>>> Ed To find the lowest price of *each* item, simply use the MIN() function for each row. With Row1 for headers, and data starting in A2, with prices listed in G2,K2, and P2, enter this in say Q2: =MIN(G2,K2,P2) And copy down as needed. SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > In this particular spreadsheet I have 23C x 361R with various types of data. > In column A I have an ITEM # and in columns G,K &P I have prices for 3 [quoted text clipped - 20 lines] > >>>> Thanks in advance. > >>>> Ed Agreed but the OP did not make it clear how he wanted to locate the row. SignatureBernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email > To find the lowest price of *each* item, simply use the MIN() function for > each row. [quoted text clipped - 35 lines] >> >>>> Thanks in advance. >> >>>> Ed As always, we await the OP's feed-back.<g> SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Agreed but the OP did not make it clear how he wanted to locate the row. > > To find the lowest price of *each* item, simply use the MIN() function for [quoted text clipped - 41 lines] > >> >>>> Thanks in advance. > >> >>>> Ed Thank you both for you help. The MIN formula worked great. I could not get the other formula to work. To add to my request. If I apply a different color to the 3 columns, G-K-P is it possible for the MIN result to show the color? > As always, we await the OP's feed-back.<g> >> Agreed but the OP did not make it clear how he wanted to locate the row. [quoted text clipped - 48 lines] >> >> >>>> Thanks in advance. >> >> >>>> Ed I would assume that what you're really after is the vendor with the lowest price. With the vendor's name in Row1 of each of the columns in question, this may ... or ... may not work, depending on what data you have in the other columns between the ones containing the prices. With the MIN() function in Q2, enter this formula in R2: =INDEX($G$1:$P$1,MATCH(Q2,G2:P2,0)) And copy down as needed. This should return the column label of the vendor's name with the lowest price, as long as there isn't any conflicting data in the intervening columns. SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Thank you both for you help. The MIN formula worked great. I could not get > the other formula to work. [quoted text clipped - 59 lines] > >> >> >>>> Thanks in advance. > >> >> >>>> Ed Thank you for all the help. Perfect! Request has been satisfied. >I would assume that what you're really after is the vendor with the lowest > price. [quoted text clipped - 97 lines] >> >> >> >>>> Thanks in advance. >> >> >> >>>> Ed You're welcome, and appreciate the feed-back. Just how many names do you use anyway?<bg> SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Thank you for all the help. Perfect! Request has been satisfied. > [quoted text clipped - 104 lines] > >> >> >> >>>> Thanks in advance. > >> >> >> >>>> Ed This is the last one. :) > You're welcome, and appreciate the feed-back. > [quoted text clipped - 126 lines] >> >> >> >> >>>> Thanks in advance. >> >> >> >> >>>> Ed I gave some thought to the possibility that it was you posting the same type of question just 52 minutes ago in this group.<g> SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > This is the last one. :) > [quoted text clipped - 132 lines] > >> >> >> >> >>>> Thanks in advance. > >> >> >> >> >>>> Ed
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.