Calling a Value

[trendon]

Note: I tried to search but I am so naive that I don't even know what to search for.

Snippet: https://i.imgur.com/mqaFGRp.png

Two Parts

1. I want to be able to type "Dustin Johnson" (B2) in another cell (let's say 'Z1' for example) and have the value in the final column (B13) appear in 'Z2'. What function do I use?

2. I want to compare "Dustin Johnson" (B2) to "Padraig Harrington" (B1) and have the sum of (B12) and (B13) appear in (Z3)

I hope I am clear; my lack of understanding of Excel is matched only by my lack of understanding of the terminology! Thanks in advance.

 

[Eric W]

Yes, I think you've got rows and columns confused. Try to show the row/column headings in your picture, or better, use the HTML Maker in my signature. A better picture results in more people being able/willing to look at it. In the table below, I copied the data from columns A and L only. I put random data in the rest, because I didn't want to type everything from your picture.

But based on what you said, I think you just need a VLOOKUP, like this:

	A	B	C	D	E	F	G	H	I	J	K	L	M	Y	Z	AA
Name	Header1	Header2	Header3	Header4	Header5	Header6	Header7	Header8	Header9	Header10	Header11	Name	Dustin Johnson	Padraig Harrington
Padraig Harrington
Dustin Johnson
Sangmoon Bae
Rob Oppenheim
Charlie Belian

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0.384[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.343[/TD]
[TD="align: right"]0.384[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]10[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0.343[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.727[/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]0.335[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0.301[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0.285[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Z2[/TH]
[TD="align: left"]=VLOOKUP(Z1,$A$2:$L$6,12,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]AA2[/TH]
[TD="align: left"]=VLOOKUP(AA1,$A$2:$L$6,12,FALSE)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Z3[/TH]
[TD="align: left"]=Z2+AA2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



For the second part, I used a second VLOOKUP in AA2, then in Z3 just added Z2 and AA2. Let me know if this is what you're looking for.

 

[jtakw]

Hi,

Your description does not match the picture you posted.
1. What do you mean B13? Do you mean N2 instead?
2. What do you mean compare Dustin Johnson to Padraig Harrington? What are you comparing?
3. I believe you have Columns and Rows mixed up in your description.

 

[trendon]

Thank you guys for the answer and the patience as I botched the post!