rabbitsfeat
New Member
- Joined
- Jun 18, 2017
- Messages
- 20
I have 2 workbooks, the first one has empty columns and I want to pull that data from another workbook. They look like this:
<tbody>
</tbody>
<tbody>
</tbody>
What I need is a function that takes the email address in column A of sheet1, finds it in sheet 2 (which is a separate workbook), then finds the data in columns C and D for that email address, and pulls it back into sheet one, into colums C and D.
Because the data I want is to the left of the email address in sheet 2, I can't figure out how to pull the data from columns C and D at the same time. I can do them one at a time but not both together... is this possible?
Here's what I have so far:
{=INDEX([EbayAmazonWeeklyRepot.xlsx]Sheet1!$C$1:$C$5,MATCH(A1,[EbayAmazonWeeklyRepot.xlsx]Sheet1!$F$1:$F$5,0))}
That pulls the data from column C, then this for column D:
{=INDEX([EbayAmazonWeeklyRepot.xlsx]Sheet1!$D$1:$D$5,MATCH(A1,[EbayAmazonWeeklyRepot.xlsx]Sheet1!$F$1:$F$5,0))}
I've used INDEX and MATCH because as far as I can tell, VLOOKUP can't look left.
I also tried looking for a function that reverses the order of the columns in the second workbook, but to no avail.
If anyone can help me with this I'd be extremely grateful.
A | B | C |
bob@comic.com | ||
geoff@live.co.uk | ||
bobby@live.co.uk | ||
bill@hotmail.com | ||
wes@sky.com |
<tbody>
</tbody>
A | B | C | D | E | F |
6/18/2017 | 111-2222222-3333333 | 1179714 | JA5939 | AMZ | bob@comic.com |
6/18/2017 | 222-3333333-4444444 | 1179723 | NE1347 | AMZ | geoff@live.co.uk |
6/18/2017 | 333-4444444-5555555 | 1179727 | JE1133 | AMZ | bobby@live.co.uk |
6/18/2017 | 444-5555555-6666666 | 1179722 | DA5721 | AMZ | bill@hotmail.com |
6/18/2017 | 555-6666666-7777777 | 1179745 | SA2294 | AMZ | wes@sky.com |
<tbody>
</tbody>
What I need is a function that takes the email address in column A of sheet1, finds it in sheet 2 (which is a separate workbook), then finds the data in columns C and D for that email address, and pulls it back into sheet one, into colums C and D.
Because the data I want is to the left of the email address in sheet 2, I can't figure out how to pull the data from columns C and D at the same time. I can do them one at a time but not both together... is this possible?
Here's what I have so far:
{=INDEX([EbayAmazonWeeklyRepot.xlsx]Sheet1!$C$1:$C$5,MATCH(A1,[EbayAmazonWeeklyRepot.xlsx]Sheet1!$F$1:$F$5,0))}
That pulls the data from column C, then this for column D:
{=INDEX([EbayAmazonWeeklyRepot.xlsx]Sheet1!$D$1:$D$5,MATCH(A1,[EbayAmazonWeeklyRepot.xlsx]Sheet1!$F$1:$F$5,0))}
I've used INDEX and MATCH because as far as I can tell, VLOOKUP can't look left.
I also tried looking for a function that reverses the order of the columns in the second workbook, but to no avail.
If anyone can help me with this I'd be extremely grateful.