Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP IF
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP IF
Hi Zsolt Szabó,
I went through your query... Upto me I think you dont have to confuse about If and Vlookup combinations and all... For the below problem you can very well use Advance filter. Set the criteria range as: (Instead of typing as size, enter the size which ur requested actually by customer. size <$40.00 Advance Filter: (set to copy to another location) 1.) Select range of your data 2.) select the typed criteria range in the second column 3.) Fix the cell where u want the result. 4.) Toggle Unique records only. Thanks and Regards, S. Praburam On Jan 13, 8:48 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |