Vlookup...How to add to it!

CAPT.PT

New Member
Joined
Mar 2, 2002
Messages
32
Someone else started a vlookup table...I know nothin about it...how do I add things to it?
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
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.
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,937
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top