Lookup Up Set Value Go to Source Cell VBA

Hello,

Is there a way to look up a fixed value and go to the source cell in a spreadsheet?

Ex. in Vlookup it would be (vlookup="NY",A:Z,15,0)

So I want to look up column containing NY and give me the result in column 15.

Any help would be amazing!

You would do something like this but you left out some information:

How do you want to specify what "fixed value" it should search for?
What action do you want to trigger this? Push a button? Change a value?

Please Login or Register  to view this content.

If you name the pictures according to the state they represent this could be straightforward in VBA. You would have them all call the same Sub and then modify the above code as shown:

Please Login or Register  to view this content.

Change Sheet1 to whatever sheet contains your data.