Nested if sums

Hi there wondered if you could help, im trying to do a nested if sum but cant seem to get it to work,

From the attached:

What i want to do is something like if A2= D2,D3 or D4 then B2="Export" if not then it = "UK"

Thanks

G'day

Try this at B2 and copy drag down.

Please Login or Register  to view this content.

Cheers