V Lookup

[cookienova]

Hello all,

I am not new to Excel. However, I have trouble creating V Lookup's. What is the best way to go about learning to creating a V Lookup?

Ebony

 

[BrianJN1]

Take a quick look at this table.

When one enters a number in D3 an item from Column 3 in the table appears in E3
If the 3 in in the formula is changed to a2, then an item from Col 2 will appear.

What the formula is saying: that find in the column of the range the corresponding item to the number found in D3.

Does that help you understand Vlookups, or do you need more guidance?
Excel 2013/2016

	A	B	C	D	E
Seek	Found
cat	carrot	peas
dog	potato
fox	lettuce
elephant	peas
mouse	beans

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

[TD="align: center"]2[/TD]
[TD="bgcolor: #F4B084"]No[/TD]
[TD="bgcolor: #F4B084"]Item A[/TD]
[TD="bgcolor: #F4B084"]ItemB[/TD]

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

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

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

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

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

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

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

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

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

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

[TD="align: center"]8[/TD]
[TD="align: right"][/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] "]E3[/TH]
[TD="align: left"]=VLOOKUP(D3,A3:C7,3,0)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Paladin6962]

Use the Insert function feature and select vlookup. It will bring up a window.

The lookup value is what you want to look up. It has to be in column A in the workbook you are using the formula in. So if you put the formula in row 3 it would have to be A3.

Table array is the workbook you want it to search in. Select all or just a portion. Then in Col_index_num you put the column you want the data to be pulled from.

So lets say that you want to find the data from A3 on the start workbook in workbook B and the data you want to reference is column d you would put the number of the column which is 4 E=5 f=6 etc.

Range_lookup is typically "false" for 99% of the vlookups I do.

 

[AhoyNC]

This link may help,
https://www.youtube.com/watch?v=-hJxIMBbmZY