david.paton
Registered User.
- Local time
- Today, 07:51
- Joined
- Jun 26, 2013
- Messages
- 338
Could someone help me understand how this formula for Excel works please?
=IF(OR(ISBLANK(A4),ISBLANK(C4),ISBLANK(D4)),0,VLOOKUP(CONCATENATE(A4," ",C4," ",D4),Service_Price_List,2,FALSE))
=IF(OR(ISBLANK(A4),ISBLANK(C4),ISBLANK(D4)),0,VLOOKUP(CONCATENATE(A4," ",C4," ",D4),Service_Price_List,2,FALSE))