LOOKUP or IF-MIN ?

[anonymust]

I got a sheet which I am tryna get in order

I think I need to use a LOOKUP formula or something, but I'm not sure how to use it.

I've attached a sample of the sheet which I am working with. (well not attached but uploaded to google documents) [https://docs.google.com/spreadsheet/...1F1MFNaZTdKNGc]

In Column C I want it to display the name which the item is cheapest. (per kilo or per litre)

[tuph]

I looked at your worksheet but it gives me lots of #VALUE errors. Perhaps if you actually attach the worksheet it will work better.

[dilipandey]

Hi anonymust,

It would be better to work around if you could attach the sample file here only.. While replying click on "Go advanced"and look for a paper clip icon to upload. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[bebo021999]

In C4: =INDEX($D$1:$Q$1,MATCH(MIN(IF($D$1:$Q$1="Per KG",$D3:$Q3)),$D3:$Q3,0)-1)
Confirmed with Ctrl-Shift-Enter rather than Enter only.
Copy down.
Does it help?

[anonymust]

MIN or LOOKUP.xls

Here is the attachment,


And I also get the #Value Errors.. its because nothing is being calculated.

[dilipandey]

Hi anonymust,

See the attachment where I have updated other formulas as well

Regards,
DILIPandey

<click on below 'star' if this helps>