Help with Match Formula

[troy_lee]

This is the formula in cell B4 on a sheet named Switchboard.

=Dates!A&(MATCH(B3,Dates!$B$3:$B$60,1)+2)

I am getting a #Name? failure in cell B4. When I isolate the Match formula, it works fine.

I am trying to pull the value of cell A19 on the Dates worksheet. I want this value to appear in cell B4 on the Switchboard worksheet. The match function is to determine what row on the Dates worksheet the value should be returned from. Adding 2 to the match function compensates for the relative offset of the function.

Thanks in advance.

TL

 

[Aladin Akyurek]

Looks like...

Either:

=INDEX(Dates!$A$3:$A$60,MATCH(B3,Dates!$B$3:$B$60,1))

Or:

=INDEX(Dates!$A$3:$A$60,MATCH(B3,Dates!$B$3:$B$60,0))

If none above, care to elaborate?

 

[troy_lee]

Yes. Thank you so much. This is huge, a veritable breakthrough. This board rocks!!!