formula help - look up on two criteria

[markster]

Morning all

I was wondering if anyone could help me with a formula. I need to create a lookup using 2 criteria (department in column A and department in row 4.


All the departments are listed A5 to A50 and Months B4:L4.

So the first one would be Finance is in cell A5 and January is B4 and so on.

I've tried adding to a regular VLOOKUP formula but it just doesn't seem to work.

Thanks in advance.

Regards
Mark

 

[JackDanIce]

Hi Mark,

Bit more info needed, where are you looking the data up from? What is your current VLOOKUP formula. Your screen is infront of you, so are you describing the problem sufficiently a blind person can understand (i.e. can a blind person guess from above what sheet this is needed on, where the data exists to look up?

Being precise = less clarification questions and easier to suggest solution