Multiple search criteria

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.
 
P

Pete_UK

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
 
J

jaysan3

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