Search for Serial # in another sheet and then copy from row below

[stangz71]

In the attachment you will see a tab "Summary Info" and in the A column there are Serial Numbers. I would like to look up the serial number in the "Summary Info" sheet on the "Maint_Info" sheet and look across into the "Pro-Rated Thru Maintenance $" column and pull the cell right below it. So for example, if I lookup serial number "355252" on the "Maint_Info" sheet, I would like it to copy " $21,886.00" into D2 on the "Summary_Info" sheet. Thanks in advance.

[YasserKhalil]

Hello
Try this code

Please Login or Register  to view this content.

[stangz71]

Is there a way for the number of columns in between the serial numbers and the information to be a variable? See attached images.

[YasserKhalil]

I don't understand what you mean. Can you explain in details the problem?
Have you tested the code provided?

[stangz71]

The serial number may contain letters and numbers, and can have a longer string and want to make sure that can be covered with the macro? Also, the amount of columns between the serial number and the "Pro-Rated Thru Maintenance $" column may change and was wondering if you can adjust the macro to fit these situations? Sorry for all these adjustments but thanks for all your help in advance.

[YasserKhalil]

Can you upload real sample of your real data so as to be able to understand the problem well .. ?
Have you checked the code on your real file .. How were the results?

[stangz71]

The original code you sent worked fine but here is the actual layout of the spreadsheet so you can understand my issue (attached).

[YasserKhalil]

Is that what you want ..?

Please Login or Register  to view this content.

[stangz71]

I ran the macro but it didn't copy the information into the U column (Pro-Rated Thru Maintenance $) in the "Summary_Info" sheet?

[YasserKhalil]

Can you post the expected results please?
If you need to put the results in column U then try to change that line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[stangz71]

I attached a spreadsheet with the results I am looking for in column U on the "summary_info"tab. The results are in red, thanks.

[YasserKhalil]

OK try this version ..

Please Login or Register  to view this content.

[stangz71]

Khalil

Thanks for your help with the request, the script worked.

[YasserKhalil]

You're welcome. Glad it worked for you

Please mark the thread as solved
Regards