Sum if for words not numbers

I have a sheet that has 3 columns: Job #, Job Owner, and Job Name. This sheet has around 80 Jobs on it and i want to use it as a reference.

each month i have to issue reports for each job as they come in. I want to make a sheet that will have the same 3 columns as list above. But when I type in the Job Name the Job Owner and Job # will automatically be filled in. I have tried a Sumif but it doesnt work correctly since it is words and not numbers

can anyone help me with the formula that will make this work?

.
Consider this your first sheet where you will enter the Job Name:

	A	B	C
1​	Job Name	Job Owner	Job Number
2​	Job1	Adam	A1
3​	Job20	Tina	A20
4​

This is the second sheet with a Table named ListNumberName2. (You can call it anything you want so long as you change the name in the formula).

	A​	B​	C​
1​	Job Name	Job Owner	Job Number
2​	Job1	Adam	A1
3​	Job2	Beth	A2
4​	Job3	Charles	A3
5​	Job4	Donna	A4
6​	Job5	Eric	A5
7​	Job6	Felicia	A6
8​	Job7	Geoff	A7
9​	Job8	Hannah	A8
10​	Job9	Ian	A9
11​	Job10	Jackie	A10
12​	Job11	Keith	A11
13​	Job12	Laura	A12
14​	Job13	Mark	A13
15​	Job14	Nina	A14
16​	Job15	Oliver	A15
17​	Job16	Penny	A16
18​	Job17	Quentin	A17
19​	Job18	Rachel	A18
20​	Job19	Steve	A19
21​	Job20	Tina	A20

On the first sheet, B2 enter : =IFERROR(VLOOKUP(A2,ListNumberName2,2,FALSE),"")

Same first sheet, C2 enter : =IFERROR(VLOOKUP(A2,ListNumberName2,3,FALSE),"")

Highlight both B2 and C2 then drag both down as far as required.

When you enter Job Name in A2, B2 & C2 will populate accordingly.


This is only one way to accomplish what you are needing. This formula utilizes VLOOKUP