I am writing some code. I want to have a function similar to VLOOKUP that will just return the column that contains a string that I pass.
For example, I have the value "Part 123" and column A in my spreadsheet contains:
I want to be able to return the row containing the value Part 123. If the value is not found, then return something else (0, -1, #EEROR#). Is there a 'built-in' function that I can make use of from within VBA to do this within my macro?