vlookup hlookup, match or indexClosed

Question

Hello, 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

panzanni · Answer

hi,
try this link to get full information about what you are trying to do:
http://www.springerlink.com/content/k624628231u18213/
this is a book where you can find the solution.

varuns · Answer

Hi,

can some one tell me how to use vlookup?

Thanks in advance.

Regards,
 Varun.

vijay · Answer

It's too simple. visit youtube.com, type search "vlookup or hlookup", you will get to see live video demo......... what's more......... cheers vijay

Dawood · Answer

This tutorial helped me much to understand vlookup:

http://www1.myhowtoos.com/?tm=1&kw=Informative+Blog&KW1=Keyboard%20Shortcuts%20Learning%20Management%20System&KW2=Computer%20Programming%20Training%20Online&KW3=Subscription%20Management%20Software&searchbox=0&domainname=0&backfill=0

Vlookup hlookup, match or index

4 responses

Similar discussions

Subscribe To Our Newsletter!