I have to spread sheets with similar fields but one has ITEM number and the
other one doesn't.

I need them to match so i can have the same item number on the same product
form the other spread sheet. here is an example:

I Have on both spread sheet:

A B C D E
Title Brand Gender name Size

I need all the fields to match exactly so when Title,brand, gender ,name ,
size match it should return the item number that is on the second spread
sheet:

A B C D E F
Title Brand Gender name Size Item#

Any help ? thanks