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)
