how do I vlookup a cell with mulitple data to match another another multiple data,

[kemi2299]

Hi guys,

i have just joined the forum and I am looking to lookup a cell(that has multiple description) with another multiple data in the column. any idea on how to go about it. thanks

149 London Road
25 Mile House Lane
10 Leyland Avenue
22 Leyland Avenue
12 Tavistock Avenue
5 Tavistock Avenue


Lime Tree Manor Residential Home
Erskine Hall Care Centre
River Court Residential and Nursing Home
Margaret House
Highview Lodge
Pinewood Lodge
Northwood Nursing Home

[alansidman]

We need more information to understand your issue. Perhaps an explanation in simple language of what you are trying to do with examples. Maybe even a sample worksheet with a before and after scenario. Your current explanation is not sufficient or clear. Pretend we are standing in line to go to the movies and you are telling me about your issue.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[kemi2299]

thanks alan,

unfortunatly, i cannot upload the file because i am at work and the server its not allowing it. but these data i have included above means two sets of data in separte worksheets, now i am trying to lookup a value in one worksheet that will identity in another worksheet, so lets say, "Lime Tree Manor Residential Home" is in the worksheet, and I need to find this appearing in another worksheet and copy it. now its ok to do it if its just say (Lime in one worksheet and Lime in another worksheet) but when its sets of data seperated by space, its difficult to use vlookup to find it, is this possible to do?

Vic

[Sam Capricci]

Let's say Lime Tree Manor Residential Home is in sheet1 cell A1 and the data is in sheet2 and Lime Tree Manor Residential Home is somewhere in column B.
You can write =vlookup(A1,sheet2!B1:D10000,4,false) and it will return the 4th column value over in sheet2 when it finds the first instance of Lime Tree Manor Residential Home.
Or you can write =vlookup("Lime Tree Manor Residential Home",sheet2!B1:D10000,4,false) and that should work too.
You can also make a distinct list and then point your vlookup to the distinct list.
hope that helps.