title: VLookup if Lookup Value Located in Column to the Right of Table Array
body: <p>I have a spreadsheet set up, and it already contains a lot of data. The A column holds date objects and column B holds numerical values. I want to use Vlookup to find the numerical value and to return the corresponding date value. The problem is that Vlookup searches in the leftmost column of the table array, which is a problem since the column holds dates. This would be easy to do if I was looking up dates, but how can I do it for looking up the numerical value. I understand that swapping the date and numerical column would do it, but I'm looking for a solution that allows me to keep the structure of my spreadsheet intact.</p>