?
Solved

Excel Formula to Grab data from one tab and add to another

Posted on 2014-11-05
1
Medium Priority
?
146 Views
Last Modified: 2014-11-05
I have an XLS with two tabs (all & winloss)
 
both tabs have an ID in column A

in tab all column B is blank and I would like it to equal column D from win loss when the value in all column A has a match in winloss column A, if there is no match the field should remain blank
0
Comment
Question by:Matt Pinkston
1 Comment
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 2000 total points
ID: 40424882
=iferror(vlookup(A2,winloss!a:d,4,false),"")

This should go into cell B2 of all, and then copy down.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

616 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question