Hlookup help

  • Thread starter Thread starter Ed S
  • Start date Start date
E

Ed S

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
 
I'm sorry. You are correct. I want to take what is in C3 and fine the lowest
value in G,K & P3.
 
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.
 
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
 
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.
 
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?
 
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.
 
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>
 
Back
Top