Labels from Excel, conditional on data

[PeterNJ]

Hello all,
I've got a vexing problem with Office 2007. I have a spreadsheet that tracks customer data, including the customers' names and mailing addresses with each row (record). I would like to do what I'm going to call a conditional mail merge. By this I mean if a customer places an order for a given month, then his/her name will be populated into an Avery 5160 label (based on the weight of the mailing--I have a column entiled weight (col. H). If H3 is empty, then customer 3 gets no mailing. If H4 contains any numerical value, customer 4 gets a mailing label generated.

I can find any number of tutorial videos on Youtube on how to do a simple mail merge with Excel+Word, but I can find nothing to do what I've just described.

Any thoughts?

Thanks in advance!

[FDibbins]

not sure if I understand you, but vlookup() will go and look for a specific value, in a defined range, and return data from whichever column you choose...
=VLOOKUP(what-you-want-to-find,range-to-search-in,column-that-contains-the-match,FALSE) FALSE is for finding an exact match

if that is not what you want, i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, what your expected outcome is, and how you arrived at that

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.