PlusBob
New Member
- Joined
- Feb 16, 2016
- Messages
- 15
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
- MacOS
- Mobile
- Web
Without using VBA (government PCs with it's security), I want to link a if another cell matches the criteria then copy and paste it.
I have an employee tracker on a workbook. One with sheet 1 (Current), it's all of the info that I need to include where are they sitting (location and cube#). Needless to say it has personal info on it. On another sheet 2 in the workbook (Location 1), I have an image with columns. The image is a floor plan with quick location numbers (1-108), the columns are: Quick Location# - Location 1# (these are the actual cube#) - Employee Name - Phone (desk) - Remarks. This sheet gets printed to PDF for the all to see.
I want the formula to read sheet 1 to find on each row that matches the Location 1# cell in sheet 2, and then populate the Employee Name and Phone column from sheet 1 to sheet 2.
(I'm sorry that I'm not explaining this correctly, asking for something already asked for (I did look), or asking for magic to happen know that this is a spreadsheet not a sorcerer's cauldron.)
Thank you for your insights and wisdom and your time spent on this.
I have an employee tracker on a workbook. One with sheet 1 (Current), it's all of the info that I need to include where are they sitting (location and cube#). Needless to say it has personal info on it. On another sheet 2 in the workbook (Location 1), I have an image with columns. The image is a floor plan with quick location numbers (1-108), the columns are: Quick Location# - Location 1# (these are the actual cube#) - Employee Name - Phone (desk) - Remarks. This sheet gets printed to PDF for the all to see.
I want the formula to read sheet 1 to find on each row that matches the Location 1# cell in sheet 2, and then populate the Employee Name and Phone column from sheet 1 to sheet 2.
(I'm sorry that I'm not explaining this correctly, asking for something already asked for (I did look), or asking for magic to happen know that this is a spreadsheet not a sorcerer's cauldron.)
Thank you for your insights and wisdom and your time spent on this.
| Sheet 1: Current | Sheet 2: Location 1 | ||||||||||
| Employees | Location | Cube | Desk Phone | Quick Loc# | Cube | Employee | Phone | ||||
| Adams, John | 1 | A200 | 303-555-1212 | 1 | A200 | Adams, John | 303-555-1212 | ||||
| Adams, John Q | 2 | B100 | 303-555-1213 | 2 |
|
|
| ||||
| Arthur, Chester | 1 | A201 | 303-555-1214 | 3 | A202 | Hamilton, Alex | 303-555-1217 | ||||
| Bob, Plus | 1 | Closet | 303-555-1215 | 4 | A203 | ||||||
| Franklin, Ben | 2 | B101 | 303-555-1216 | 5 | A204 | ||||||
| Hamilton, Alex | 1 | A202 | 303-555-1217 | 6 | A205 | ||||||
| Lincoln, Abe | 2 | B102 | 303-555-1218 | 7 | Closet | Plus, Bob | 303-555-1215 |
Thank you--that is exactly what I needed! And, educational, because I had never knew what to use IFNA statement for. Thank you very much for your time on this--really appreciate it!
