VLookup Problem

G

griff2311

I can successfully use vlookup when using only two collums bu
unfortunatly i need the function to work on 9-10 collums.

Is there a way to incorporate more than two collums when using vlookup
If not is there anyway to accomplish what vlookup does with two collum
on more than two collums?

thanks
 
P

Peo Sjoblom

You can have as many columns as there are in excel using vlookup, that is
where the index number comes in

=VLOOKUP(lookup_value,Table,column_index,TRUE/FALSE)

so if you want exact match from the 9th column use

=VLOOKUP(lookup_value,Table,9,FALSE)

if you want to have column 1 - 9 use

=VLOOKUP(lookup_value,Table,COLUMNS($A$1:B1),FALSE)

make sure the lookup value cell and the table range are absolute (like
$B$1:$J$200) and copy across will return the values from 2nd, 3rd, 4th and
so on

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
S

Steve Farrar

You can concatenate the columns you want to use
For example if ColA is Apples and ColB is oranges use a formula like
"=A1&B1"
You also need to do that in the table whjere the lookup info is
 
B

Biff

Hi!

You can use as many columns as there are (currently, 256).

Describe your problem in more detail.

Biff
 
G

griff2311

Peo, i've tried and i am still having no luck.

Biff:

I have a 9x18 table (A6:I23) and i want my return value from the 9t
collum (I). My look up value is in C1. I can get it to work if i se
my table up in two collums, but that results in a ton of unnessisar
data. There are not many details past that it's pretty simple i jus
cannot get it to work
 
Top