Lookup difficulties

  • Thread starter Thread starter Ams
  • Start date Start date
A

Ams

Is there any look function available in xl which can provide all
common data from the sheet. Currently i am using vlookup function to
sort common records between two sheets but the problem is its only
provide the first data which comes from ascedning order also suggest
if any function availabe to find out common words from two cells.

Thanks in advance


Regards
 
Any other option pls....

Not able to make out

Visit Chip's site and search fro 'duplicates'. He has lots on info on this
subjectwww.cpearson.com
best wishes
--
Bernard V Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme
remove caps from email








- Show quoted text -
Click to expand...
 
Any other option?


Visit Chip's site and search fro 'duplicates'. He has lots on info on this
subjectwww.cpearson.com
best wishes
--
Bernard V Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme
remove caps from email








- Show quoted text -
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match based on a lookup and then flag 4
Lookup Cell Interior 1
Referencing a workbook in a lookup 1
Vlookup 6
lastrow function help 6
Help with Excel sheets 3
Need help with simple macros for double checking manual plugs 4
database ODBC custom formula retrieval and other 2

Back
Top