M
Mike
can vlookup be used to find multiple matches in a table on sheet 2 for a
single index number on sheet 1?
single index number on sheet 1?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Eduardo
Hi,
could you post an example, it will help to see what you want to achieve.
Thanks
could you post an example, it will help to see what you want to achieve.
Thanks
M
Mike
I want the entries on sheet 2 for "1570" to to appear on the line with "1570"
on sheet 1. The number of entries for a number on sheet 2 varies.
SHEET 1 SHEET 2
6071 1560 54900
6309 1564 70900
4027 1570 43300
1570 1570 44200
2904 1570 44800
1579 73800
1582 74304
1582 74306
on sheet 1. The number of entries for a number on sheet 2 varies.
SHEET 1 SHEET 2
6071 1560 54900
6309 1564 70900
4027 1570 43300
1570 1570 44200
2904 1570 44800
1579 73800
1582 74304
1582 74306
E
Eduardo
Hi,
I assume you want the sum from sheet 2 of all the entries for "1570"
Assuming in sheet 2 column B has the number you want to add
in sheet1 column B enter
=sumproduct(--(A1=sheet2!$A$1:$A$1000),sheet2!$B$1:$B$1000)
change range to fit your needs but remember you have to enter the same range
in both sides of the formula.
I assume you want the sum from sheet 2 of all the entries for "1570"
Assuming in sheet 2 column B has the number you want to add
in sheet1 column B enter
=sumproduct(--(A1=sheet2!$A$1:$A$1000),sheet2!$B$1:$B$1000)
change range to fit your needs but remember you have to enter the same range
in both sides of the formula.
M
Mike
Eduardo, I appreciate your efforts to help me, but you do not need to waste
additional time on this. I do not want the sum of the entries on sheet 2, I
want the actual numbers. In my example, which contained spacing when I typed
it, I want 43300, 44200, and 44800 to be brought forward to sheet 1 and be
stored in cells on the line for 1570 (1570 ... 43300 44200 44800). Thanks
again for you help!
additional time on this. I do not want the sum of the entries on sheet 2, I
want the actual numbers. In my example, which contained spacing when I typed
it, I want 43300, 44200, and 44800 to be brought forward to sheet 1 and be
stored in cells on the line for 1570 (1570 ... 43300 44200 44800). Thanks
again for you help!
M
Mike
Thanks for the help. This stuff is new to me and I'm trying to run before I
learn to walk. Deadlines are a bitch. Thanks again.
learn to walk. Deadlines are a bitch. Thanks again.