Apache OpenOffice Community Forum

Posted: **Sat Jul 11, 2015 2:51 am**

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

Posted: **Sat Jul 11, 2015 3:27 am**

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.

Posted: **Sat Jul 11, 2015 4:25 am**

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

Posted: **Sat Jul 11, 2015 4:47 am**

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))

Posted: **Sat Jul 11, 2015 5:09 am**

Thats Great
Thank you

Michael

Apache OpenOffice Community Forum

[Solved] VLOOKUP to the left column?

[Solved] VLOOKUP to the left column?

Re: VLOOKUP to the left column?

Re: VLOOKUP to the left column?

Re: VLOOKUP to the left column?

Re: VLOOKUP to the left column?