Finding 1st value in row if prior cells in the row are blank

[NotaVBAeXpert]

Hi,

I am trying to find the amount located in specific cell based on month/year(x/xx). I have multiple worksheets; the first worksheet showing what value to look up and the specific date, for example... I need to lookup value 454839 on 1/13(January 2013).

My 2nd worksheet shows the data with the lookup values going down Column A and the dates across the columns in the 1st row.

I currently have a vlookup and match function:

(=VLOOKUP(A30,'Std Values'!C:CG,MATCH('Non-Std Calc '!G30,Sheet5!$C$1:$CG$1,0),FALSE)

But I need help figuring out a macro or formula if the output from my above formual is blank.because there is a value in those cells. I would need the next value in that particualr row which would match the value in the row.Any ideas?

 

[NotaVBAeXpert]

Would you test whether the following edit succeeds?

=INDEX('Std Values'!$D$2:$CG$400,MATCH(1,IF('Std Values'!$C$2:$C$400=$A115,IF(ISNUMBER(1/INDEX('Std Values'!$D$2:$CG$400,0,MATCH($G115,'Std Values'!$D$1:$CG$1,0))),1)),0),MATCH($G115,'Std Values'!$D$1:$CG$1,0))

That doesn't work either. Hmmmm. it is still showing a #N/A

 

[Aladin Akyurek]

That doesn't work either. Hmmmm. it is still showing a #N/A

Given the following data:

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][/tr][tr][td]

1​

[/td][td][/td][td]

5/4/2018​

[/td][td]

5/5/2018​

[/td][td]

5/6/2018​

[/td][/tr]
[tr][td]

2​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

3​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

4​

[/td][td]a[/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

5​

[/td][td]a[/td][td]

0.2​

[/td][td][/td][td][/td][/tr]
[tr][td]

6​

[/td][td]b[/td][td]

0.9​

[/td][td][/td][td][/td][/tr]
[tr][td]

7​

[/td][td]c[/td][td]

6​

[/td][td][/td][td][/td][/tr]
[tr][td]

8​

[/td][td]c[/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

9​

[/td][td]d[/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

10​

[/td][td]d[/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

11​

[/td][td]d[/td][td]

0.8​

[/td][td][/td][td][/td][/tr]
[tr][td]

12​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

13​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

14​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

15​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table]

what would be the result for a and 5/4/2018?