If statements

[Graysleaf]

Good morning,

I would like to know how to write an IF statement that is capable to do the following:

=IF(C3:I8)(Sheet1) contains "5229" then copy A3 of same row(Sheet1) and paste to (Sheet4) B2

Any ideas?

 

[Graysleaf]

Essentially I'm trying to accomplish the following:

I will have a spreadsheet with column A containing about 200 names of employees.
Column B thru ZZ will be consecutive dates of the year.
The array B2:ZZ200 will be serial numbers of customers that my employees are assigned to.
I'm using the spreadsheet as a schedule to assign who the employees will be working for.
The present day (column B) will have a number or serial number representing a customer.
There will be multiple employees assigned to the same customer.
For all the employees that are assigned to customer "5229" I would like there names to be copied and pasted into a text box on another sheet so that I could move them around as a group.
The reason for the text box is to be overlaid on a map of where the customer is located. i.e.: slot 2N or 3S (locations on the map)

Any help would be great

 

[Aladin Akyurek]

You have given a solution. Have you test it at all?