column a has zip codes.
column b has zip codes.
column c is blank. i want to input ZIP CODE MATCH in column c if the zip in column a is found in column b. how can i do this?
thank you
column a has zip codes.
column b has zip codes.
column c is blank. i want to input ZIP CODE MATCH in column c if the zip in column a is found in column b. how can i do this?
thank you
Assuming your data starts in row 1, try this in C1:
Formula:
Please Login or Register to view this content.
Drag down
Hope this helps![]()
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Hi semantics
In C1 put the following formula:
Formula:
Please Login or Register to view this content.
And copy down as far as required.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks