I can successfully use vlookup when using only two collums but
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 collums
on more than two collums?

thanks.


--
griff2311
------------------------------------------------------------------------
griff2311's Profile: http://www.excelforum.com/member.php...o&userid=35805
View this thread: http://www.excelforum.com/showthread...hreadid=555794

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


"griff2311" wrote
in message ...

I can successfully use vlookup when using only two collums but
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 collums
on more than two collums?

thanks.


--
griff2311
------------------------------------------------------------------------
griff2311's Profile:
http://www.excelforum.com/member.php...o&userid=35805
View this thread: http://www.excelforum.com/showthread...hreadid=555794

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
"griff2311" wrote
in message ...

I can successfully use vlookup when using only two collums but
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 collums
on more than two collums?

thanks.


--
griff2311
------------------------------------------------------------------------
griff2311's Profile:
http://www.excelforum.com/member.php...o&userid=35805
View this thread: http://www.excelforum.com/showthread...hreadid=555794

Hi!

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

Describe your problem in more detail.

Biff

"griff2311" wrote
in message ...

I can successfully use vlookup when using only two collums but
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 collums
on more than two collums?

thanks.


--
griff2311
------------------------------------------------------------------------
griff2311's Profile:
http://www.excelforum.com/member.php...o&userid=35805
View this thread: http://www.excelforum.com/showthread...hreadid=555794

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 9th
collum (I). My look up value is in C1. I can get it to work if i set
my table up in two collums, but that results in a ton of unnessisary
data. There are not many details past that it's pretty simple i just
cannot get it to work.


--
griff2311
------------------------------------------------------------------------
griff2311's Profile: http://www.excelforum.com/member.php...o&userid=35805
View this thread: http://www.excelforum.com/showthread...hreadid=555794

Hi

Try
=VLOOKUP(C1,$A$6:$I$23,9,0)

--
Regards

Roger Govier


"griff2311"
wrote in message
...

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 9th
collum (I). My look up value is in C1. I can get it to work if i set
my table up in two collums, but that results in a ton of unnessisary
data. There are not many details past that it's pretty simple i just
cannot get it to work.


--
griff2311
------------------------------------------------------------------------
griff2311's Profile:
http://www.excelforum.com/member.php...o&userid=35805
View this thread:
http://www.excelforum.com/showthread...hreadid=555794

I appreciate the help guys.


--
griff2311
------------------------------------------------------------------------
griff2311's Profile: http://www.excelforum.com/member.php...o&userid=35805
View this thread: http://www.excelforum.com/showthread...hreadid=555794