anthony20069
01-20-2009, 02:49 AM
Hi guys,
Need your help (once again :) )... With a Vlookup is it possible to match two rows and then put in the value.... so...
In one sheet A1 is Surname B1 is Forename in F1 is Completed (contains Yes or No)... in another sheet I need to match the surename and forname to give me what there completion status is (yes or no), the problem is if I just do it with A1 there are a few people with the same Surname same goes for B! Forename.
Any suggestions?
Thanks very much
Need your help (once again :) )... With a Vlookup is it possible to match two rows and then put in the value.... so...
In one sheet A1 is Surname B1 is Forename in F1 is Completed (contains Yes or No)... in another sheet I need to match the surename and forname to give me what there completion status is (yes or no), the problem is if I just do it with A1 there are a few people with the same Surname same goes for B! Forename.
Any suggestions?
Thanks very much