Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookup

Vlookup

ResolvedVersion 2003

Wed 15 Oct 2008, 16:40 Delegate wayne said...

wayne has attended:
Excel Intermediate course

Vlookup

how do I edit a v:lookup to enter something in a cell as opposed to the formula so the cell acts like a search box?

Thu 16 Oct 2008, 11:47 Trainer Amanda said...

RE: vlookup

Hi Wayne

Thank you for your question and welcome to the forum.

The VLOOKUP function has 4 parts - for the first part of the function (the lookup value), you can refer to a cell (e.g. A3) and then type into that cell what is it that you would like Excel to look for in the first/left most column of the table array (second part of the function). Then you can use cell A3 like a search box.

I hope this helps.
Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips

Vlookup

Vlookup

RE: vlookup

Excel articles

Excel tip:

##### displaying in Excel