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

 
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
lookup multiple search criteria but only return a value if both tr se7098 Excel Worksheet Functions 8 October 7th 08 10:11 PM
Search for multiple criteria, and return yet another JMG Excel Worksheet Functions 5 March 12th 08 08:33 PM
Multiple search criteria to return one response Dan Excel Worksheet Functions 3 March 3rd 06 03:44 AM
How do I search excel spreadsheets using multiple search criteria. Kasper Excel Worksheet Functions 4 December 15th 05 12:26 AM
Search string with multiple criteria fLiPMoD£ Excel Worksheet Functions 2 May 5th 05 08:02 PM


All times are GMT +1. The time now is 05:01 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"