Searching within VLookup Results

[smaumau]

I am having trouble using the find function within the results of a vlookup. For example, the result of my vlookup includes one cell = 123 Main Street. When I attempt to search for 123 Main Street with ctrl + F, it doesn't find the record.

Any suggestions would be greatly appreciated.

Thanks.

[VBA Noob]

Does changing to look in from "value" to "formula" help

http://www.bettersolutions.com/excel...I013811412.htm

VBA Noob

[smaumau]

It was set on look in "formula"

I changed it to value and it works. It's always something simple, thanks for your help.