Hello!
I'm hoping someone could help me figure this out..
If b2=sheet2!b:b and (same row) c:c =sheet2!D
then Sheet2!k:K, else blank
B2 is an IDNumber and the rows of the “C” column are years, while the “K” column shows various locations. Basically I need the IDNumber listed for the various years to show each location listed.
Is this a simple paste or is it a looping effect?
Any help will be greatly appreciated.
I'm hoping someone could help me figure this out..
If b2=sheet2!b:b and (same row) c:c =sheet2!D
then Sheet2!k:K, else blankB2 is an IDNumber and the rows of the “C” column are years, while the “K” column shows various locations. Basically I need the IDNumber listed for the various years to show each location listed.
Is this a simple paste or is it a looping effect?
Any help will be greatly appreciated.