Possible to find a cell based on a row header (col A) then a sub-row header (col B)

assuming the company names begin at A2 and month names begin at B2 (A1 and B1 contain title), and you put the company name that you want to find in cell D1 and the month name that you want to find in E1,, try this:

Please Login or Register  to view this content.

Thank you, mohd9876, I will give that a shot.

mohd9876: I've played around with the suggestion you have provided, but I can't get it to work. I've replaced the cell references with variables, and it throws an error (Method 'Range' of object '_Global' failed).

Please Login or Register  to view this content.

Specifically, I am trying to paste the data in a variable (InvData) to the cell in column H, where column A = the company (variable "currComp") and column B = (variable "currMonth")

I probably should have been more specific from the beginning - apologies. Any ideas?

well, it works for me, could you post your workbook and ill see what the problem may be

mohd9876 - Thanks for the prompt reply. I think I have it working now. I was passing in the variable incorrectly. I now have it written as below and it seems to be working just fine in the mockup sheet.

Please Login or Register  to view this content.

Many thanks!