Forum Discussion
Melissa McDowell
Nov 20, 2018Copper Contributor
IF statement or VLOOKUP?
What I want it to do is search the 'instruments' sheet to see if any of those words come up in the titles on the titles sheet in column 1. I then want it to display that instrument in column D of the...
- Nov 21, 2018
I think I got it.
pls see attached file.
thanks..
Lorenzo Kim
Nov 20, 2018Bronze Contributor
pls see attached file.
hope you can make something out of it.
thanks..
- Melissa McDowellNov 21, 2018Copper Contributor
Hi Lorenzo,
Thank you so much. That is amazing. Is there any way to make it just leave it blank if it can't find anything matching in the 'instruments' sheet?
- Lorenzo KimNov 21, 2018Bronze Contributor
I think I got it.
pls see attached file.
thanks..
- Melissa McDowellNov 21, 2018Copper Contributor
Amazing. I can't thank you enough.