Multiple search criteria

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

 

[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

 

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