MrExcel Publishing
Your One Stop for Excel Tips & Solutions

vlook up


Posted by Roy Hernandez on December 16, 2001 10:33 AM

I have a seven column spread sheet but the info i need to use vlook up and transfer to another spreadsheet starts in column 5 info on columns 1-3 is not important but i cannot delete or alter the spreadsheet.
A B C D E F G
1 11 25 35 45
2 12 55 65 75
3 85 95 100 105

IN OTHER WORDS, I WANT TO USE VLOOKUP ON COLUMN D AND TRANSFER ANSWERS FROM E,F & G TO OTHER SPREADSHEET. THANKS FOR THE HELP, Roy


Posted by Jacob on December 16, 2001 4:06 PM

Hi

Im not 100% sure what you want, but maybe this will help:

What do you want to look for in the vlookup?

In D1 put = vlookup(WhatImLookingFor,"E1:G3",column you want the vlookup to get its answer from,false)

Hope this gets you started.

Jacob

Posted by Marcellus on December 17, 2001 5:01 AM

I would start by blocking the range D1:G3 and naming it Hookers. In the Formula I would point the Lookup_value to the cell in Column D that you would like to use as your reference for your lookup. In the Table_array you would type in Hookers and in the Col_index_num you would enter 1 (if the lookup is in Column E), 2 (for Column F), 3 (for Column G). So you end up with a formula that looks like this:
=VLOOKUP(<your number or cell ref>,Hookers,1)

Hope this helps

Marcellus

I have a seven column spread sheet but the info i need to use vlook up and transfer to another spreadsheet starts in column 5 info on columns 1-3 is not important but i cannot delete or alter the spreadsheet.


Posted by Marcellus on December 17, 2001 5:04 AM

Oops, formula should look like this:

:=VLOOKUP(YourNumberOrCellRef,Hookers,1)