Multiple search criteria

  • Thread starter Thread starter jaysan3
  • Start date Start date
J

jaysan3

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.
 
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
 
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.
 
Back
Top