Using loop and finding the right row combination?

[hvisa]

Hello,
In my attachment, I have two sheets, with same columns in both sheets.
Now, wherever,I have #VALUE! error in sheet 2, for the same combination in col A,B from sheet 1, I want it to grab the values from C,D,E,F from sheet 1 and paste it on the error values in sheet 2. There are almost 1000 rows, So I would like to do this using the check condition, if column 3 has # VALUE!, then copy data from sheet 1 for the same combination from column A and B.

Thanks for your help.

[TMS]

I'm not sure if this is what you are looking for:

Cell C2: =VLOOKUP($A2,Sheet1!$A$1:$F$5,COLUMN(C$1),FALSE)

Please Login or Register  to view this content.

Regards

[nimrod]

Hello hvisa:
From the mention of "loop" and the "macro" name in your sheet I'm assuming you are looking for a macro solution. Also , from you example, I'm assuming the "#value!" is actually a string ... if these assumptions are correct then this macro should help you ...

Please Login or Register  to view this content.

[hvisa]

Thank you so much,nimrod. Yes, I was looking for a macro solution and that worked perfectly.
Thank you TMShucks for your help.

[nimrod]

HI hvisa:
Glad that worked out for you.

Cheers