phendrena
12-08-2008, 09:13 AM
Hello,
I have a rather large worksheet of users, IDs, passwords, dealer numbers and dealer names. Not all of the user ids and passwords have been allocated. I have been given the missing ones as a seperate worksheet.
Now, without going down 700+ additions I would like to come up with a formula that'll do the job for me. If it was a simple VLOOKUP I wouldn't have any problems however, as the users can be assigned to several dealership (and have different user ids and passwords) I can't use a straight forward VLOOKUP.
So the formula should fill in the cell if the user name and also dealer code match.
Can anyone assist me with this one please?
Thanks,
The example sheet i've uploaded is a very basic example.
I have a rather large worksheet of users, IDs, passwords, dealer numbers and dealer names. Not all of the user ids and passwords have been allocated. I have been given the missing ones as a seperate worksheet.
Now, without going down 700+ additions I would like to come up with a formula that'll do the job for me. If it was a simple VLOOKUP I wouldn't have any problems however, as the users can be assigned to several dealership (and have different user ids and passwords) I can't use a straight forward VLOOKUP.
So the formula should fill in the cell if the user name and also dealer code match.
Can anyone assist me with this one please?
Thanks,
The example sheet i've uploaded is a very basic example.