If Cell 1 in Sheet 1, Matches Cell 1 in Sheet 2, then copy and paste Cell 2, 3, & 4 to Sheet 2 Cell 2, 3 & 4

[PlusBob]

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.

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	A201	Arthur, Chester	303-555-1214
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

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D
1	Employees	Location	Cube	Desk Phone
2	Adams, John	1	A200	303-555-1212
3	Adams, John Q	2	B100	303-555-1213
4	Arthur, Chester	1	A201	303-555-1214
5	Bob, Plus	1	Closet	303-555-1215
6	Franklin, Ben	2	B101	303-555-1216
7	Hamilton, Alex	1	A202	303-555-1217
8	Lincoln, Abe	2	B102	303-555-1218
9
Sheet1

+Fluff 1.xlsm
	A	B	C	D
1	Quick Loc#	Cube	Employee	Phone
2	1	A200	Adams, John	303-555-1212
3	2	A201	Arthur, Chester	303-555-1214
4	3	A202	Hamilton, Alex	303-555-1217
5	4	A203
6	5	A204
7	6	A205
8	7	Closet	Bob, Plus	303-555-1215
Sheet2

Cell Formulas
Range	Formula
C2:C8	C2	=IFNA(INDEX(Sheet1!$A$2:$A$8,MATCH(B2,Sheet1!$C$2:$C$8,0)),"")
D2:D8	D2	=IFNA(INDEX(Sheet1!$D$2:$D$8,MATCH(B2,Sheet1!$C$2:$C$8,0)),"")

 

[PlusBob]

How about

+Fluff 1.xlsm
	A	B	C	D
1	Employees	Location	Cube	Desk Phone
2	Adams, John	1	A200	303-555-1212
3	Adams, John Q	2	B100	303-555-1213
4	Arthur, Chester	1	A201	303-555-1214
5	Bob, Plus	1	Closet	303-555-1215
6	Franklin, Ben	2	B101	303-555-1216
7	Hamilton, Alex	1	A202	303-555-1217
8	Lincoln, Abe	2	B102	303-555-1218
9
Sheet1

+Fluff 1.xlsm
	A	B	C	D
1	Quick Loc#	Cube	Employee	Phone
2	1	A200	Adams, John	303-555-1212
3	2	A201	Arthur, Chester	303-555-1214
4	3	A202	Hamilton, Alex	303-555-1217
5	4	A203
6	5	A204
7	6	A205
8	7	Closet	Bob, Plus	303-555-1215
Sheet2

Cell Formulas
Range	Formula
C2:C8	C2	=IFNA(INDEX(Sheet1!$A$2:$A$8,MATCH(B2,Sheet1!$C$2:$C$8,0)),"")
D2:D8	D2	=IFNA(INDEX(Sheet1!$D$2:$D$8,MATCH(B2,Sheet1!$C$2:$C$8,0)),"")

You the Fluff! 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!

 

[Fluff]

You're welcome & thanks for the feedback.