Thread: IF statement with multiple VLOOKUPs
View Single Post
  #5   Report Post  
GijsKijlstra GijsKijlstra is offline
Junior Member
  
Location: Singapore
Posts: 20
Send a message via Skype™ to GijsKijlstra
Default
Quote:
Originally Posted by Spencer101 View Post
Your current formula appears to work if every name is on each sheet.
The fact that Harry does not appear on Sheet2 or Sheet3 means the formula stumbles with an #N/A at that point and cannot carry on.

Leave it with me and I shall see what I can do for you.

S.
That would be great Spencer. Looking forward to it,

Gijs
Reply With QuoteReply With Quote