| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple search criteria
I need to find an exact match from 2 or more search criterias. I tried
VLookup but it only searches one criteria. For example, I need to find the Job No, based on the exact Serial No & Model. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple search criteria
You can do this by inserting a new column in your lookup table and
then concatenating Serial No & Model in that new column. Then in your VLOOKUP you use the new column and concatenate the two sought items together. Hope this helps. Pete On Jan 14, 9:18*am, jaysan3 wrote: I need to find an exact match from 2 or more search criterias. I tried VLookup but it only searches one criteria. For example, I need to find the Job No, based on the exact Serial No & Model. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple search criteria
Hi Pete,
That would not be possible as they are seperate data and used for other reports too. I am still playing with Index or Match function but am stumped. "Pete_UK" wrote: You can do this by inserting a new column in your lookup table and then concatenating Serial No & Model in that new column. Then in your VLOOKUP you use the new column and concatenate the two sought items together. Hope this helps. Pete On Jan 14, 9:18 am, jaysan3 wrote: I need to find an exact match from 2 or more search criterias. I tried VLookup but it only searches one criteria. For example, I need to find the Job No, based on the exact Serial No & Model. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup multiple search criteria but only return a value if both tr | Excel Worksheet Functions | |||
| Search for multiple criteria, and return yet another | Excel Worksheet Functions | |||
| Multiple search criteria to return one response | Excel Worksheet Functions | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
| Search string with multiple criteria | Excel Worksheet Functions | |||
Linear Mode
