vlookup
can vlookup be used to find multiple matches in a table on sheet 2 for a
single index number on sheet 1? |
vlookup
Hi,
could you post an example, it will help to see what you want to achieve. Thanks "Mike" wrote: can vlookup be used to find multiple matches in a table on sheet 2 for a single index number on sheet 1? |
vlookup
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 "Eduardo" wrote: Hi, could you post an example, it will help to see what you want to achieve. Thanks "Mike" wrote: can vlookup be used to find multiple matches in a table on sheet 2 for a single index number on sheet 1? |
vlookup
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. "Mike" wrote: 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 "Eduardo" wrote: Hi, could you post an example, it will help to see what you want to achieve. Thanks "Mike" wrote: can vlookup be used to find multiple matches in a table on sheet 2 for a single index number on sheet 1? |
vlookup
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! "Eduardo" wrote: 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. "Mike" wrote: 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 "Eduardo" wrote: Hi, could you post an example, it will help to see what you want to achieve. Thanks "Mike" wrote: can vlookup be used to find multiple matches in a table on sheet 2 for a single index number on sheet 1? |
vlookup
Try This This will help you 'Multiple Vlookup results as a text string - MrExcel Message Board' (http://tinyurl.com/lb2hcr) -- hardeep.kanwar ------------------------------------------------------------------------ hardeep.kanwar's Profile: http://www.thecodecage.com/forumz/member.php?userid=170 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=108878 |
vlookup
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. "hardeep.kanwar" wrote: Try This This will help you 'Multiple Vlookup results as a text string - MrExcel Message Board' (http://tinyurl.com/lb2hcr) -- hardeep.kanwar ------------------------------------------------------------------------ hardeep.kanwar's Profile: http://www.thecodecage.com/forumz/member.php?userid=170 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=108878 |
All times are GMT +1. The time now is 07:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com