Vlookup, match, index

I have tried them all and cant always get what I want. I am working between two sheets. I want to search for a value in one of those sheets that could be anywhere in a range of about 40 different columns and many rows. Right now, I can only get it to work if the search value is in the far left column. help if you can

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!