VLookup Problem

  • Thread starter Thread starter griff2311
  • Start date Start date
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
 
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
 
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
 
Hi!

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

Describe your problem in more detail.

Biff
 
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
 
Back
Top