Select the intersecting cell of 2 values

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?

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

Aussie Grid said:

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

Click to expand...

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

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