Vlookup hlookup, match or index
Last answer on Jul 10, 2009 10:11:13 am BST ralmahen, on Mar 16, 2009 10:02:35 am GMTHello, I have a question regarding my excel problem..
I have two sheets of excels files containing a large range of data, is it possible to find overlaping data on those sheets using vlookup/hlookup function in a same time (search a range of data in one sheet through both columns and rows of data in another sheet).
Here for example,let's say i have a list of patents from firm A (sheet A); and list of patent from firm B (sheet B), each patent have their own references lists. What is the formula if i want to find which patent from firm A have overlapping references with firm B)
thanks, your assistance will be appreciated
Configuration: Windows XP Firefox 3.0.6
Hi,
|
This tutorial helped me much to understand vlookup:
|
"index of /" toner cartridge- Change a excel cell colour vba list of color index
- Cod 5 two player xbox live private match
- Combine index() and match()
- Excel 2007 how to match same number 2 column
- Excel formula index match
- Excel vba vlookup multi column match
- Google desktop index external drive
- Iexplorer index.dat format
- Index filter excel
- Index of / helvetica neue 77 bold condensed
- The file header checksum does not match the computed checksum f1
- The gateway ip address 0.0.0.0 of the printer does not match your router. reconfigure the setting on your printer to match.
- Vba copying columns index
- Vlookup match two columns
- Vlookup to match data on 2 sheets
- Vlookup to match values between columns
- Wireless security settings do not match
