Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding matching cell data
I have a worksheet showing a column of file names e.g. XY1234X XY5678X XY2468X XY4321X etc and another worksheet containing a column of file paths e.g. I:\Sales\AllUsers\Marketing\115001 - North East\XY1234X I:\Sales\AllUsers\Marketing\115001 - North East\XY8765X I:\Sales\AllUsers\Marketing\115002 - North\XY4321X I:\Sales\AllUsers\Marketing\115003 - North West\XY5678X What I'd like to do is cross reference them to see if any of the file names appear in any of the paths. I tried using VLOOKUP by adding a column to the right of the path column with the letter "Y" in it and asking for this "Y" to be returned in the event that the file name appeared in the path but it returned "#N/A" indicating that the data was not found (even though the test Lookup value was definitely contained in one of the paths in the table array). I'm pretty sure I'm barking up the wrong tree with VLOOKUP and would maybe be better off with an IF function of some kind. Does any one have any ideas, please? -- SRL ------------------------------------------------------------------------ SRL's Profile: http://www.excelforum.com/member.php...fo&userid=6748 View this thread: http://www.excelforum.com/showthread...hreadid=516137 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
data in cell not corresponding with entry | New Users to Excel | |||
Input Cell in One variable data table | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |