Hi, good morning everybody

I need your help! I have a list and I like to use it like this. Colum A =
Product Name A2:A18 ; Row 1 = Size B1:U1 ; The prices of these products are
in cells B2:U18 . When my costumer is asking me a list €“ for example $40.00
or cheaper products list - I like to give them a list and make sure there is
no duplication in it. I tried the VLOOKUP IF formula but I couldnt make it
right.

--
Many thanks for your help in advance. Have a wonderful day!
Zsolt

One way to highlight the resultset is using a conditional formatting
where you put in a greater than cell value rule assuming the data is
as per structure below

Name Small medium large
p1 3 4 34
p2 34 43 65
p3 34 101 101
p4 234 45 43
p5 44 345 455



criteria value
40



Regards
Anirudh

On Jan 13, 8:46 pm, Zsolt Szabó
wrote:
Hi, good morning everybody

I need your help! I have a list and I like to use it like this. Colum A =
Product Name A2:A18 ; Row 1 = Size B1:U1 ; The prices of these products are
in cells B2:U18 . When my costumer is asking me a list - for example $40.00
or cheaper products list - I like to give them a list and make sure there is
no duplication in it. I tried the VLOOKUP IF formula but I couldn't make it
right.

--
Many thanks for your help in advance. Have a wonderful day!
Zsolt