Syntax help: Match Cells Pick Value

[Rustyf2003]

Greetings from the Bluegrass State -
Have a time with much calculation - On final Round though I am having difficulty with this one

Cell: B3 contains a date entered by User

Cells: G15 through G30 contain dates
Cells: H15 through H30 contain Values

Am Looking to AutoFill Cell C3 with the VALUE found in respective H Row where B3 = G##

Any help much appreciated - and please know I HAVE TRIED TO FIGURE THIS OUT
r

 

[Haseeb Avarakkan]

Hello,

If you just have one occurance of the lookup date (B3) try the VLOOKUP in C3,

=VLOOKUP(B3,G15:H30,2,FALSE)

If you have multiple occurances & you need to show all the matching dates,

C3, Confirmed with Control+Shift+Enter, not just Enter. copy down...

=INDEX($H$15:$H$30,SMALL(IF($G$15:$G$30=$B$3,ROW($H$15:$H$30)-ROW($H$15)+1),ROWS(C$3:C3)))

 

[Rustyf2003]

Thanks Haseeb: I had tried variations of the VLookup without success
and the Index(syntax) didn't provide a result

Cell B3 = 8/1/2011

Cell G15 = 8/1/2011 { Cell H15 = 29
Cell G16 = 8/1/2012 { Cell H16 = 41
Cell G17 = 8/1/2013 { Cell H17 = 53
and continues
..............

My Need
In Cell C3 I need to autopopulate the value from the matched B and G Cells
If B3 = G15 - I Need C3 to fill with value from H15 (29)
If B3 = G16 - I Need C3 to fill with value from H16 (41)
If B3 = G17 - I Need C3 to fill with value from H17 (53)

Again, any assistance and guidance is much appreciated
Rusty

 

[Haseeb Avarakkan]

You need to press Control+Shift+Enter, not just Enter. in the INDEX(.....
Select C3, press F2 then hit Control+Shift+Enter.

Copy down.

 

[Rustyf2003]

Thanks Haseeb:
GOT IT - YOUR HELP IS MUCH APPRECIATED.
Rusty