Lookup problem

**cercle92** · 03-07-2014, 06:39 AM

Hi everyone

I can't upload my excelfile because the content is secret, but this is how it looks like

Colom A Colom B
1/01/2014 40000
2/01/2014 30000
3/01/2014 20000
4/01/2014 35000
5/01/2014
6/01/2014
7/01/2014
8/01/2014
9/01/2014
10/01/2014
11/01/2014
12/01/2014
13/01/2014
14/01/2014
15/01/2014
16/01/2014
17/01/2014
18/01/2014
19/01/2014
20/01/2014
22/01/2014
23/01/2014
24/01/2014
25/01/2014
26/01/2014
27/01/2014
28/01/2014
29/01/2014
30/01/2014
31/01/2014
Jan X

At the X spot I want a formula that automatically gives me the most recent numbers (35000). If I add the next day a new number I want at the X spot that new number. Is there a formula who can do that? I don't know anything about VBA, so that's not a solution. I thought about a concatenate function, but that doesn't work.

Thanks in advance

**:) Sixthsense :)** · 03-07-2014, 06:54 AM

Instead of pasting the data inside the post show it in excel with expected result for giving exact solution

**cercle92** · 03-07-2014, 07:02 AM

Noobquestion, but how do I add a file?

**:) Sixthsense :)** · 03-07-2014, 07:04 AM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**cercle92** · 03-07-2014, 07:09 AM

Book1.xlsx
This is the dataset. I cannot give you the exact dataset because that's secret

**:) Sixthsense :)** · 03-07-2014, 07:20 AM

In B29 Cell

=LOOKUP(2,1/(B1:B28<>""),A1:A28)

**cercle92** · 03-07-2014, 07:25 AM

If I do that, excel gives an error: A1 is turned in black, so I think there is the fault. But no idea what it could be. Did you used the formula in the file, and did it work?