VLookup on multiple columns
Hi I want to carry out a Vertical Lookup but the Lookup Value is contained in 2 columns. Can this be done or would it be best to Concatenate the 2 columns into one? Thanks Shirley Munro -- Shirley Munro ------------------------------------------------------------------------ Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836 View this thread: http://www.excelforum.com/showthread...hreadid=493021 |
VLookup on multiple columns
Without a specific example, it's difficult to give you specific help... Meanwhile, I believe this website will get you headed in the right direction: http://www.xldynamic.com/source/xld.SUMPRODUCT.html I hope that helps. Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=493021 |
VLookup on multiple columns
Do you mean that you want to match based on the input in two columns?
If yes... You can use this kind of syntax: =index(othersheet!$c$1:$c$100, match(1,(a2=othersheet!$a$1:$a$100)*(b2=othersheet !$b$1:$b$100),0)) (one cell) This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.) Adjust the range to match--but you can't use the whole column. Shirley Munro wrote: Hi I want to carry out a Vertical Lookup but the Lookup Value is contained in 2 columns. Can this be done or would it be best to Concatenate the 2 columns into one? Thanks Shirley Munro -- Shirley Munro ------------------------------------------------------------------------ Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836 View this thread: http://www.excelforum.com/showthread...hreadid=493021 -- Dave Peterson |
VLookup on multiple columns
I vote for the CONCATENATION option...........I use it all the time.
Vaya con Dios, Chuck, CABGx3 "Shirley Munro" wrote: Hi I want to carry out a Vertical Lookup but the Lookup Value is contained in 2 columns. Can this be done or would it be best to Concatenate the 2 columns into one? Thanks Shirley Munro -- Shirley Munro ------------------------------------------------------------------------ Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836 View this thread: http://www.excelforum.com/showthread...hreadid=493021 |
All times are GMT +1. The time now is 07:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com