Could you please help what I want to do is:-
if a customers name on my main summary sheet is on my worksheet then say “Previous” or if a name appears on my worksheet and not on my summary sheet I then ant to show the customers name on my summary sheet.
For example:-
“Previous” Joe Bloggs = Name appears on worksheet and Summary
“Previous” Fred Bloggs = Name appears on worksheet and summary
“Previous” John Bloggs = Name appears on worksheet and summary
Sid Bloggs = Name isn’t on the summary but appears on the worksheet
James Bloggs = Name isn’t on the summary but appears on the worksheet
I tried the following formula but failed miserably - I couldnt return the name from the worksheet.
Regards
if a customers name on my main summary sheet is on my worksheet then say “Previous” or if a name appears on my worksheet and not on my summary sheet I then ant to show the customers name on my summary sheet.
For example:-
“Previous” Joe Bloggs = Name appears on worksheet and Summary
“Previous” Fred Bloggs = Name appears on worksheet and summary
“Previous” John Bloggs = Name appears on worksheet and summary
Sid Bloggs = Name isn’t on the summary but appears on the worksheet
James Bloggs = Name isn’t on the summary but appears on the worksheet
I tried the following formula but failed miserably - I couldnt return the name from the worksheet.
Code:
=IF(ISNUMBER(MATCH(B4,'Previous- worksheet'!A:A,0)),"Previous",IF(ISNUMBER(MATCH('Previous- worksheet'!A3,Summary!B:B,0)),"Paid",0))
Regards