pulling state data from another sheet

I

Item Manager

I'm currently collecting contact info from States which consist of primary
and alternate POC's. One State may have 7 POC's and another 10. I received
them as (See Example):

Column A, Column B, Column C
AL Primary Jonn Doe
PA Primary Jonn Doe
PA Alternate Jonn Doe

I then consolidate all data (which could be 5,000 rows) and paste the info
into a new workbook on sheet 1. For sheet 2, I simply have it setup in
column B all 54 States and Territories abbr and in column C is where I would
like to create the formula. On sheet 2, if column B1 is AL, then the formula
in C1 will look up applicable info in sheet 1 and indicate the word
"received", if info is in range. I'm not concern with the number of times AL
is listed on sheet 1, just want the info to be recognized in sheet 2 as
received. Please provide a formula for me if there is one. Thanks.
 

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

Similar Threads

Bringing to a cell the last date an event occurred 6
CountIf from multiple sheets in another workbook 4
pulling from one sheet to another 3
pulling data 3
comparing sheet to sheet and adding value 1
How to create a crosstab in Excel 1
copy rows from one Data sheet to another sheet based on cell conte 2
using countif on sheet 2 6

Top