[Solved] VLOOKUP to the left column?

[TengoKbailar]

Hi All,
I am trying to use VLOOKUP to find a name in column J and return the date it was entered from column A. All the examples show returning a result from the column to the right of the search column. Can you tell me if VLOOKUP only works to the right and if/how I can find the date I need.

Thanks

Michael

[RusselB]

I'd suggest using a combination of INDEX and MATCH rather than VLOOKUP
VLOOKUP only returns information located to the right of the lookup column.

[TengoKbailar]

Hi RusselB,
I thought that would be the case with VLOOKUP.
I can do the match part but how do I incorporate the INDEX into the formula?
Thanks
Michael

[FJCC]

The formula will have the form

Code: Select all

=INDEX(A2:A100;MATCH())

assuming the dates you want to return are in the range A2:A100. If the value you are looking for is in B1, the formula might be

Code: Select all

=INDEX(A2:A100;MATCH(B1;J2:J100;0))

[TengoKbailar]

Thats Great
Thank you

Michael