I have the following conditions:
- I have a Workbook with 2 WorkSheets named Data and Users
- In Data, I have column A populated with numbers ranging from 1 to 9999999
- In Users, I have column A populated with numbers ranging form 1 to 9999999
- In Users, I have multiple rows of each of the numbers (example 10 rows of 1, 18 rows of 2, 32 rows of 3, etc.)
- In Data, cells B, C and D are empty
- In Users, cells B, C and D contain email, first name, last name
What I am trying to do is to copy Users : B, C and D values to Data : B, C and D empty cells.
I'm trying to use the INDEX and MATCH functions, but cannot get it to run - continually getting errors.
Here is an example of what I've tried in a test cell in my Users sheet:
=INDEX(Users!A:A,MATCH(1,(A2=Data!:A:A),0))
So, to clarify. I have:
Users sheet:
A B C D
1 me@me.com First Last
Data sheet:
A B C D
1
1
1
1
My objective is to populate every row in Data with the values of Users B, C and D whenever the value in column A matches.
The end result would look like:
Data sheet:
A B C D
1 me@me.com First Last
1 me@me.com First Last
1 me@me.com First Last
1 me@me.com First Last
Thanks in advance.