I'm new too the board, but thought I'd try my luck. I'm trying too use the V-Look Up Feature and too pull data from one spreadsheet to another. However, the source column in the spreadsheet I'd like too pull data from not only has the matching word/characters but other data as well separated by spaces. Is there a way for V-Look Up to do this, or is there another feature in Excel?? I've been trying to resolve this issue for years, I normally end up doing it manually. Can anyone help?