Vlookup Across Multiple Columns

Mar 9th, 2002, 09:01 PM

I need to compare several columns in two separate worksheets. I can do that by making long records of each row (A1&B1&C1, etc.) then doing a vlookup on the long records to find the exact matches, but that seems ackward.

Is there a form of vlookuop that will allow comparing across several columns? (8 columns in my application)

Dave Hawley · Mar 9th, 2002, 09:05 PM

Hi

I have a Custom function written here that will do this. Just ad an If statement to include only the sheets you want.

Josue Barocio · Mar 9th, 2002, 09:16 PM

Thanks for the instant response Dave, but I don't see your code. Do I need some special setting in my Internet Explorer?

Dave Hawley · Mar 9th, 2002, 09:27 PM

Oops sorry, my fault I forgot the link

)

http://www.ozgrid.com/VBA/VlookupAllSheets.htm

nisht · Mar 9th, 2002, 10:10 PM

I have a small programme..

compare range..

you can download it from my excel site..

http://www.pexcel.com/download.htm

i think this small utility can be useful to you.
nishith desai

[ This Message was edited by: nisht on 2002-03-09 21:11 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 9th, 2002, 09:01 PM	#1
Guest Posts: n/a	I need to compare several columns in two separate worksheets. I can do that by making long records of each row (A1&B1&C1, etc.) then doing a vlookup on the long records to find the exact matches, but that seems ackward. Is there a form of vlookuop that will allow comparing across several columns? (8 columns in my application)

Mar 9th, 2002, 09:05 PM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi I have a Custom function written here that will do this. Just ad an If statement to include only the sheets you want.

Mar 9th, 2002, 09:16 PM	#3
Josue Barocio Board Regular Join Date: Mar 2002 Posts: 101	Thanks for the instant response Dave, but I don't see your code. Do I need some special setting in my Internet Explorer?

Mar 9th, 2002, 09:27 PM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Oops sorry, my fault I forgot the link ) http://www.ozgrid.com/VBA/VlookupAllSheets.htm

Mar 9th, 2002, 10:10 PM	#5
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	I have a small programme.. compare range.. you can download it from my excel site.. http://www.pexcel.com/download.htm i think this small utility can be useful to you. nishith desai [ This Message was edited by: nisht on 2002-03-09 21:11 ]