left lookup

**Justindd** · 11-18-2010, 07:39 AM

I am trying to lookup the text that sits in the column to the left of a range of dates. Basically I want to find the most recent date (currently using =max) from the date column and return the text immediately to its left. I think I need to use the left lookup function but am new to Excel do is a bit beyond me! I want to return the data in column E of 'Master' worksheet.

Spreadsheet attached, see worksheet '001' E1:F19 for data range

Thanks

**martindwilson** · 11-18-2010, 07:43 AM

where in your workbook exactly?
maybe
=INDEX('001'!E1:E19,MATCH(MAX('001'!F1:F19),'001'!F1:F19,0))

**arthurbr** · 11-18-2010, 08:28 AM

Based on this innovative solution proposed by ddll, find a solution attached

**martindwilson** · 11-18-2010, 08:31 AM

i'm not going to open that but i bet it's the choose method, coz i can see that catching on wholesale lol

**arthurbr** · 11-18-2010, 08:49 AM

Martin, please forgive my poor knowledge of English, but what does the second part of your answer mean? ( the bit about "wholesale")

**Blake 7** · 11-18-2010, 08:55 AM

Hi Arthur - Your English is fantastic.

"wholesale" = on a large scale / in large quantities.

M is implying that the Choose Function will be popular..........

Hope all well with you Sir......

**Blake 7** · 11-18-2010, 09:01 AM

Hi Guys.

I did open the ss and it's a vlookuo with choose, which I have never seen before. Could someone please take the time to translate this into English? in particular, why the curly brackets ({1,2},??

=VLOOKUP(F4,CHOOSE({1,2},'001'!$F$1:$F$19,'001'!$E$1:$E$19),2,0)

Thanks