Vlookup...How to add to it!

**CAPT.PT** · Mar 13th, 2002, 01:23 PM

Someone else started a vlookup table...I know nothin about it...how do I add things to it?

**tk19** · Mar 13th, 2002, 01:38 PM

if you go into help and look up the vlookup function (no pun intended) that should help you out. One of the arguments in the function is a range. It could be defined as in A1:E27 format, or it could be a named range, like MyDataRange. If it is the latter, you can go into the Insert-Names-Define menu and change the range, and then add your new data inside the new range.

**gplhl** · Mar 13th, 2002, 01:44 PM

just add data to where the data is looked up from, then check that the formulae that refer to it still got that far in the area that it is looking.

i.e. if the existing formula looks something like

=VLOOKUP(A1,Sheet2!$A$1:$B$20,2,FALSE)
then the cell is going to look for the value in A1 in sheet two, looking in column 1 and returning the value in column 2, in the range A1 to B20

If you added extra data and the last row you want to now look in is 300 then you would change $B$20 to $B$300

or start using named ranges replace all of $B$20 with a named range.