Select the intersecting cell of 2 values

[Aussie Grid]

I need to select the intersecting cell of 2 values.
A2:A10 = Staff names
B2:M2 = Dates (in 1 cell merged from 3)

All cells formatted as text, except the dates which are short date.

I intend to create a form that will enter data in the intersected cell as determined by 2 combos, 1 for staff and the other for dates.

Any & all help appreciated

Aussie Grid

 

[bstory84]

a2:a10 and B2:b10 a side by side. you can use vlookup.
I'm pretty sure i'm just not understanding your question. can you post a screen shot?

 

[Aussie Grid]

Sorry about the typo I've changed B2:B10 to what it should have been which is B2:O2.
It's just like an x y axis. Select the intersection of James who is one of the values in A2:A10 and a date which is one of the values along the top in B2:M2

Hope that is clearer Aussie Grid

 

[mmmarks]

Sorry about the typo I've changed B2:B10 to what it should have been which is B2:O2.
It's just like an x y axis. Select the intersection of James who is one of the values in A2:A10 and a date which is one of the values along the top in B2:M2

Hope that is clearer Aussie Grid

try dis,

=INDEX($B$2:$M2,MATCH("JAMES",$A$2:$A$10,0),MATCH("DATE",$B2$O$2,0))

but for better solution just post sample data

 

[Aussie Grid]

My fault again!
I need the answer in vba, sorry.
......A...........B ..........C........ D........E
1 ............22 May.. 23 May.. 24 May.. 25 May
2 James
3 Bill
4 Sue
5 John

I need to select the cell at James and 23 May(C2) and then insert data via a form.
The index match needs to be in vba so that it will select/activate the cell for the input.
The criteria will be picked from 2 combos linked to eg. A20 and A21 with the vba formula using these 2 cells to select the intersection ie C2
HTH.
Sorry but I have no idea about how to enter a screenshot.
Aussie Grid