VLOOKUP Result Not Searchable

[rsortilla]

When I do VLOOKUP from another sheet, the resulting data is not searchable to the current sheet where I have the VLOOKUP formula. Why is this and what's the workaround? Please help.

 

[arthurbr]

What do you mean by " not searchable"?

 

[MARK858]

Might help as well to post a sample of your data and the formula you are using.

 

[MrMajinbuu]

I think what rsortilla meant was not being able to get the search result on "VLOOKUP result". I ran into the same problem as well. Please help!

For exmaple, the Vlookup result returned a text " Pineapple orange", when you do a CTRL F to find the word "Pineapple" in the same spreadsheet ,Excel couldn't find it.

Need a workaround here.

Thanks in advance

 

[Fluff]

CTRL F then change the Look In field to Value

 

[MrMajinbuu]

Sweet. Thank you

 

[Fluff]

You're welcome