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.

Aladin Akyurek · Mar 13th, 2002, 01:51 PM

Quote:

On 2002-03-13 12:23, CAPT.PT wrote:
Someone else started a vlookup table...I know nothin about it...how do I add things to it?

Post the VLOOKUP formula for a more directed response if needed.

Aladin

Mar 13th, 2002, 01:44 PM	#3
gplhl Board Regular Join Date: Feb 2002 Location: Chippenham, UK Posts: 136	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. __________________ Regards, Gary Hewitt-Long

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 01:23 PM	#1
CAPT.PT New Member Join Date: Mar 2002 Posts: 32	Someone else started a vlookup table...I know nothin about it...how do I add things to it?

Mar 13th, 2002, 01:38 PM	#2
tk19 New Member Join Date: Mar 2002 Posts: 33	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.