Vlookup, match, index

Amanda P

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

Paul Newcome

Are you able to provide some screenshots for reference along with more details?