#1
|
|||
|
|||
Vlookup or some other formula need help
Hi there,
I have two excel files. One is source file and second target. From source file I want to copy Test Score column values to Target file's Test Score column after matching columns of Source file (name, father's name and domicile columns). I am using MS Excel 2013. Could any body help on this as soon as possible please? Thanks, |
#2
|
||||
|
||||
Hi and welcome
in the future please post in the correct forum. I moved your thread for you this time. Please post a sample sheet ( click Go advanced - Manage attachments) showing data and expected results. Pictures are nice to look at but worthless to work with. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
The formulas will be easier to write, easier to read, and will added automatically to new records (so long as the formula in column remains same), when you define both of your tables as Tables (Insert > Table, and give a meaningful name e.g. tSource and tTarget). NB! All columns in Table must have headers, so add header Area to second table too. And avoid apostrophes (and as best spaces too) in headers - like FathersName vs. FATHER's NAME.
Now select any cell in column TestScore (e.g. T2), and enter the formula If TestScore in tSource is numeric Code:
=SUMIFS(tSource[TestScore],tSource[StudentName],[@Name],tSource[FarhersName],[@FarhersName],tSource[Domicile],[@Domicile]) Code:
=VLOOKUP([@SNumber],tSource, 7, 0) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula | innkeeper9 | Excel | 2 | 09-13-2016 08:59 PM |
VLOOKUP Formula? | ekeithjohnson | Excel | 6 | 08-28-2014 01:16 PM |
Vlookup formula | teza2k06 | Excel | 2 | 03-18-2014 01:21 PM |
I think I need an IF/AND & VLOOKUP formula here | Catbert | Excel | 18 | 08-25-2013 07:38 PM |
IF + VLOOKUP formula help | skyline255 | Excel | 0 | 09-19-2012 05:05 PM |