Excel Match two columns/rows within multiple sheets then paste answer...


Joined
Jan 5, 2018
Messages
1
Reaction score
0
Hello!

I'm hoping someone could help me figure this out..

If b2=sheet2!b:b and (same row) c:c =sheet2!D: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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top