| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP with multiple criteria
I need to fatch a value by vlookup from 3 criteria. Here are the
details. In my sheet FE col A has dates, B has names, C has type and E has value. Dates and value will change daily while name and type is constant. Every day new row is added in the table. Hance name and type will be repeared on daily basis. In sheet Summary, I entered date, name and type. I need to fatch a value from sheet FE, col E where date, type and name matches the corresponding value in sheet FE. Is it possible without VBA? I would prefer a solution with formulas if possible. Regards, Madiya |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VLOOKUP with multiple criteria
=SUMPRODUCT((FE!A1:A999=A1)*(FE!B1:B999=B1)*(FE!C1 :C999=C1),FE:E1:E999)
This works if type in col. E has a numeric value. HTH -- AP "Madiya" a écrit dans le message de news: ... I need to fatch a value by vlookup from 3 criteria. Here are the details. In my sheet FE col A has dates, B has names, C has type and E has value. Dates and value will change daily while name and type is constant. Every day new row is added in the table. Hance name and type will be repeared on daily basis. In sheet Summary, I entered date, name and type. I need to fatch a value from sheet FE, col E where date, type and name matches the corresponding value in sheet FE. Is it possible without VBA? I would prefer a solution with formulas if possible. Regards, Madiya |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VLOOKUP with multiple criteria
It should work!
If you're stuck, please send me your workbook at: HTH -- AP "Madiya" a écrit dans le message de news: ... Thanks Ardus. Type in col. E has a numeric value. I have modified the formula slightly as below but it doesn't worl and returns zero. =SUMPRODUCT((FE!A1:A9999=A7)*(FE!B1:B9999=B7)*(FE! C1:C9999=C7),FE!E1:E9999) Any suggessions? Regards, Madiya Ardus Petus wrote: =SUMPRODUCT((FE!A1:A999=A1)*(FE!B1:B999=B1)*(FE!C1 :C999=C1),FE:E1:E999) This works if type in col. E has a numeric value. HTH -- AP "Madiya" a écrit dans le message de news: ... I need to fatch a value by vlookup from 3 criteria. Here are the details. In my sheet FE col A has dates, B has names, C has type and E has value. Dates and value will change daily while name and type is constant. Every day new row is added in the table. Hance name and type will be repeared on daily basis. In sheet Summary, I entered date, name and type. I need to fatch a value from sheet FE, col E where date, type and name matches the corresponding value in sheet FE. Is it possible without VBA? I would prefer a solution with formulas if possible. Regards, Madiya |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VLOOKUP with multiple criteria
Yes. It works.
Actually it was my mistake. I forgot to change the third criteria. Many thanks. Regards, Madiya Ardus Petus wrote: It should work! If you're stuck, please send me your workbook at: HTH -- AP "Madiya" a écrit dans le message de news: ... Thanks Ardus. Type in col. E has a numeric value. I have modified the formula slightly as below but it doesn't worl and returns zero. =SUMPRODUCT((FE!A1:A9999=A7)*(FE!B1:B9999=B7)*(FE! C1:C9999=C7),FE!E1:E9999) Any suggessions? Regards, Madiya Ardus Petus wrote: =SUMPRODUCT((FE!A1:A999=A1)*(FE!B1:B999=B1)*(FE!C1 :C999=C1),FE:E1:E999) This works if type in col. E has a numeric value. HTH -- AP "Madiya" a écrit dans le message de news: ... I need to fatch a value by vlookup from 3 criteria. Here are the details. In my sheet FE col A has dates, B has names, C has type and E has value. Dates and value will change daily while name and type is constant. Every day new row is added in the table. Hance name and type will be repeared on daily basis. In sheet Summary, I entered date, name and type. I need to fatch a value from sheet FE, col E where date, type and name matches the corresponding value in sheet FE. Is it possible without VBA? I would prefer a solution with formulas if possible. Regards, Madiya |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup multiple criteria | Excel Worksheet Functions | |||
| Vlookup multiple criteria multiple occurrences sum values | Excel Worksheet Functions | |||
| Vlookup with Multiple criteria and multiple sheets | Excel Worksheet Functions | |||
| Vlookup for multiple criteria, multiple worksheets | Excel Worksheet Functions | |||
| Vlookup for multiple criteria | Excel Worksheet Functions | |||
Linear Mode
