LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 239
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup multiple criteria se7098 Excel Worksheet Functions 6 August 10th 09 06:53 PM
Vlookup multiple criteria multiple occurrences sum values se7098 Excel Worksheet Functions 0 March 26th 09 07:31 PM
Vlookup with Multiple criteria and multiple sheets Cinny Excel Worksheet Functions 4 June 21st 07 01:47 AM
Vlookup for multiple criteria, multiple worksheets jtoy Excel Worksheet Functions 4 January 25th 07 09:26 PM
Vlookup for multiple criteria kieffer Excel Worksheet Functions 12 October 5th 06 07:43 PM


All times are GMT +1. The time now is 04:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"