| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching for different items
Hi
I'm creating an excel database with 2 tabs - one of which will be a front page, containing formulas to conduct a search from tab 2 - a data dump page. I understand how to do VLookups, but i'm looking for a formula which means I can search for E.g : Look for Fred, In warrington, with Volvo - is this possible to search for several items ?? Anything you can help me with will be much appreciated. RGDS Ben |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Searching for different items
=INDEX(E2:E20,MATCH(1,(A2:A20="Fred")*(B2:B20="War rington)*(C2:C20="Volvo"),0))
entered with ctrl + shift & enter -- Regards, Peo Sjoblom "B_cooper123" wrote in message ... Hi I'm creating an excel database with 2 tabs - one of which will be a front page, containing formulas to conduct a search from tab 2 - a data dump page. I understand how to do VLookups, but i'm looking for a formula which means I can search for E.g : Look for Fred, In warrington, with Volvo - is this possible to search for several items ?? Anything you can help me with will be much appreciated. RGDS Ben |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Always display items AND Include hidden items in totals | Excel Discussion (Misc queries) | |||
| SUMPRODUCT to count items with duplicates where another column contains two defined items | Excel Worksheet Functions | |||
| Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
| order form with multiple items and sizes for items | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
![B_cooper123[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
