|
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 04:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com