R
Rachelynn
How can I combine a if-search function and a Vlookup?
I'm trying to make a lookup on one worksheet that will lookup on a
different worksheet and search for data within a string, and return
only that data.
Sheet 2 -somehow combines...
vlookup (A2,Sheet1,2,False) and
if(search("x",Sheet1B2),"x")
or is there another function that does the same thing?
Help please!
Thanks
I'm trying to make a lookup on one worksheet that will lookup on a
different worksheet and search for data within a string, and return
only that data.
Sheet 2 -somehow combines...
vlookup (A2,Sheet1,2,False) and
if(search("x",Sheet1B2),"x")
or is there another function that does the same thing?
Help please!
Thanks