Link to home
Start Free TrialLog in
Avatar of Michael Dobbins
Michael Dobbins

asked on

Find and Replace in separate column

I am trying to add a find and replace feature to look for an invoice number matching what is in range C7:C28 on sheet 1, with what is in column A on Sheet 4. If there is a match, I need it to copy the text adjacent to the invoice number on sheet one in range D7:D28 into column N on Sheet 4, on the same row the matching invoice number was found. So, if Invoice # 1234 was found on sheet 4 in A5, N5 should be changed to the text from sheet 1. I am new to this so hopefully my description is adequate. if not, I can answer any questions.
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You can probably do it with a lookup function (INDEX/VLOOKUP) instead.

Can you upload some sample data?
Avatar of Michael Dobbins
Michael Dobbins

ASKER

Subodh Tiwari, that worked perfectly!! thank you!!
You're welcome Michael! Glad it worked as desired.