Hi
What code could be used in vba that will find 2 values (1 in a column and
the other in row) and once found the values if we draw a line we would reach
the cell which contains the value I require.

Currently have the following formula's in a sheet which brings back the
value I am after however I would like to put it into VBA as I keep moving the
cell due to adding more values to the column & row.

cell 1 =+IF(Sheet1!I70,MATCH(LOOKUP(Sheet1!I7,numbers),n umbers,1),"")
cell 2 =+MATCH(LOOKUP(Sheet1!E11,months),months,1)

cell with value required = IF(I70,IF(E11<"",INDEX(invoices,cell 1,cell
2),""),"")

If anyone could advise a code in VBA which will perform the same task that
would be great.

Thanks
Noemi