Vlookup in a range

[nosense]

I want the macro to use every value in corresponding rows (sheets("1").range("E8:e12") and corresponding values in "F8:f12" ) to be looked up in another sheet ("2") in range(d5:d13)

and values from sheet "1" being taken away from corresponding values in Sheets("2") and resuts pasted in "results" column.

Here an example spread sheet

[dflak]

Can you provide a sample showing what the results are supposed to look like? I might be able to reverse engineer the response. I'm not understanding the requirement from your description.

[walruseggman]

Please Login or Register  to view this content.

[nosense]

Please Login or Register  to view this content.

Perfect!
Well done. That is what I needed. Rep to you!

[nosense]

Perfect!
Well done. That is what I needed. Rep to you!

I have changed it to suit my spreadsheet and it does paste values where I want (into declare "c" variable ranges) but still get an error and macro is stopped. Error does say "Type mismatch"

My code is :

Please Login or Register  to view this content.

[nosense]

I have changed it to suit my spreadsheet and it does paste values where I want (into declare "c" variable ranges) but still get an error and macro is stopped. Error does say "Type mismatch"

My code is :

Please Login or Register  to view this content.

[nosense]

Please Login or Register  to view this content.

I have found a solution .

Please Login or Register  to view this content.