Hlookup help

[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

 

[Bernard Liengme]

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

 

[Ed S]

I'm sorry. You are correct. I want to take what is in C3 and fine the lowest
value in G,K & P3.

 

[Don Guillett]

You still have not explained very well. How about an example.

 

[Ed S]

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.

 

[Bernard Liengme]

Lets say the data is in A1:X361
In Z1 you type in an item number
In Z2:
=MIN(VLOOKUP(Z2,A1361,7 ),VLOOKUP(Z2,A1361,11 ),VLOOKUP(Z2,A1361,16 ))
best wishes

 

[Ragdyer]

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.

 

[Bernard Liengme]

Agreed but the OP did not make it clear how he wanted to locate the row.

 

[Ragdyer]

As always, we await the OP's feed-back.<g>

 

[SteelyDan]

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?

 

[Ragdyer]

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,G22,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.

 

[South Florida Ed]

Thank you for all the help. Perfect! Request has been satisfied.

 

[Ragdyer]

You're welcome, and appreciate the feed-back.

Just how many names do you use anyway?<bg>

 

[South Florida Ed]

This is the last one.

You're welcome, and appreciate the feed-back.

Just how many names do you use anyway?<bg>

 

[Ragdyer]

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>