Lookup Using Part of a Text

  • Thread starter Thread starter Rod
  • Start date Start date
R

Rod

Hello,

I have three tabs: Team Track Raw Data, Commitments Data and Commitments
Chart. Raw data looks like this:
Name Tot Prem Rec
AAAAA, John Doe $59 $616 3

I want Commitments Data to search Track Data based on first names, i.e. John
and bring back the number in the 4th col, i.e. 3. So, Commitments Data will
look like:

Name Rec
John 3

I will chart John's Rec of 3 in Commitments Chart.

Thank you for your help.
 

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

if > < on one tab - want total on a summary sheet 3
Not sure what function to use to return records that fit criteria 2
Using SumIF formulas with multiple lookup values 2
Referring to a cell by using another cell for the row number 6
Finding the weighted average of text that have been given values 1
SUMPRUDUCT 3 Pieces of Criteria 1
Lookup a name if cell value first letter is in a range 1
Total number of occurances for two text values 3

Back
Top