Index Function to reference cell 2 columns and

How can I make the index function search Column A for an Item e.g. Hospital and then return the value that is 2 columns to the left and 2 rows down? Am I best to try to use a vlookup? I'm new to the Index function and I can see the potential but struggling a bit.

Example (within the range A1:C1000):

=INDEX($A$1:$C$1000,MATCH("hospital",$A$1:$A$1000,0)+2,3)

I've amended the formula to suit my needs: =INDEX(April!$A:$P,MATCH(B4,April!$A:$P,0)+2,3) but I get a N/A.

The data I'm looking up is in column B. The data is on my "April" worksheet. The data that comes out each month is always in column A to P but can be of differing amounts, therefore I cannot assign an end row.

Any ideas?

Change the lookup area withing the match function to only one column, for example:

=INDEX(April!$A:$P,MATCH(B4,April!$A:$A,0)+2,3)

See if that works

Applying it to the whole column may slow it down somewhat, instead of limiting it to a specific row.

That's great. Cheeky question, but is there a way of coding the formula so that when I drag it across, the formula references the next month. I tried using a list of months and referencing them, e.g. S1 = April and putting that in the bit where April is, so =INDEX("S1"!$A:$P,MATCH(B4,"S1"!$A:$A,0)+2,3) but it doesnt work. I'm not sure this can be done when referencing worksheets.

Also, can I automatically get the index cell reference to increase by one when I drag it across so =INDEX(April!$A:$P,MATCH(B4,April!$A:$A,0)+2,3) becomes =INDEX(April!$A:$P,MATCH(B4,April!$A:$A,0)+2,4) becomes
=INDEX(April!$A:$P,MATCH(B4,April!$A:$A,0)+2,5) etc?