Vlookup Across Multiple Columns

[Guest]

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]

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]

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]

Oops sorry, my fault I forgot the link )


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

 

[nisht]

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.
ni****h desai
This message was edited by nisht on 2002-03-09 21:11