# VLOOKUP with duplicates

#### shemayisroel

##### Well-known Member
Hi,

I'm sure this has been addressed previously but here goes.

I'm looking for a formula solution to return the result of names even through the names may appear more than once in a list. Below is some sample data, example I would want to look up say Noah and return 2 results as Noah appears twice in the list, result 1 would be 333 and result 2 would be 200. VLOOKUP will only return the 1st instance... Any help would be great.

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD>NAME</TD><TD style="TEXT-ALIGN: center">SUM</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD>Noah</TD><TD style="TEXT-ALIGN: center">333</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD>Adam</TD><TD style="TEXT-ALIGN: center">555</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD>Sarah</TD><TD style="TEXT-ALIGN: center">777</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD>Isaac</TD><TD style="TEXT-ALIGN: center">100</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD>Noah</TD><TD style="TEXT-ALIGN: center">200</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD>Sarah</TD><TD style="TEXT-ALIGN: center">400</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD>Rebecca</TD><TD style="TEXT-ALIGN: center">700</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD>Rebecca</TD><TD style="TEXT-ALIGN: center">388</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD>Jacoob</TD><TD style="TEXT-ALIGN: center">795</TD></TR></TBODY></TABLE>

Last edited:

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

#### shemayisroel

##### Well-known Member
Thanks Aladin, I'll check it out and post back if I get stuck. But at a quick glance it seems as though you've thoroughly explained it - THANKS again!

#### shemayisroel

##### Well-known Member

I used your logic in the above link and worked well, the next hurdle was being able to produce a unique list in order to display the results under them. I used a previous post you helped me with to get the unique entries list. The below is the completed solution. The credit does go to you as all the solutions in the below example were formulated by you - so once again THANKS!

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: center">4</TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD>NAME</TD><TD style="TEXT-ALIGN: center">SUM</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD>Noah</TD><TD style="TEXT-ALIGN: center">333</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD>Adam</TD><TD style="TEXT-ALIGN: center">555</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD>Sarah</TD><TD style="TEXT-ALIGN: center">777</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD>Noah</TD><TD style="TEXT-ALIGN: center">200</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD>Sarah</TD><TD style="TEXT-ALIGN: center">400</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD>Rebecca</TD><TD style="TEXT-ALIGN: center">700</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="TEXT-ALIGN: center">Noah</TD><TD style="TEXT-ALIGN: center">Adam</TD><TD style="TEXT-ALIGN: center">Sarah</TD><TD style="TEXT-ALIGN: center">Rebecca</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="TEXT-ALIGN: center">2</TD><TD style="TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: center">2</TD><TD style="TEXT-ALIGN: center">1</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="TEXT-ALIGN: center">333</TD><TD style="TEXT-ALIGN: center">555</TD><TD style="TEXT-ALIGN: center">777</TD><TD style="TEXT-ALIGN: center">700</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="TEXT-ALIGN: center">200</TD><TD></TD><TD style="TEXT-ALIGN: center">400</TD><TD></TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>A1</TD><TD>{=SUM(IF(FREQUENCY(IF(A3:A8<>"",MATCH("~"&A3:A8&"",A3:A8&"",0)),ROW(A3:A8)-ROW(A3)+1),1))}</TD></TR><TR><TD>A10</TD><TD>{=IF(ROWS(\$A\$10)<=\$A\$1,INDEX(\$A\$3:\$A\$8,SMALL(IF(FREQUENCY(IF(\$A\$3:\$A\$8<>"",MATCH("~"&\$A\$3:\$A\$8&"",\$A\$3:\$A\$8,0)),ROW(\$A\$3:\$A\$8)-ROW(\$A\$3)+1),ROW(\$A\$3:\$A\$8)-ROW(\$A\$3)+1),ROWS(\$B\$9:B9))),"")}</TD></TR><TR><TD>B10</TD><TD>{=IF(ROWS(\$A\$10)<=\$A\$1,INDEX(\$A\$3:\$A\$8,SMALL(IF(FREQUENCY(IF(\$A\$3:\$A\$8<>"",MATCH("~"&\$A\$3:\$A\$8&"",\$A\$3:\$A\$8,0)),ROW(\$A\$3:\$A\$8)-ROW(\$A\$3)+1),ROW(\$A\$3:\$A\$8)-ROW(\$A\$3)+1),ROWS(\$B\$9:B10))),"")}</TD></TR><TR><TD>C10</TD><TD>{=IF(ROWS(\$A\$10)<=\$A\$1,INDEX(\$A\$3:\$A\$8,SMALL(IF(FREQUENCY(IF(\$A\$3:\$A\$8<>"",MATCH("~"&\$A\$3:\$A\$8&"",\$A\$3:\$A\$8,0)),ROW(\$A\$3:\$A\$8)-ROW(\$A\$3)+1),ROW(\$A\$3:\$A\$8)-ROW(\$A\$3)+1),ROWS(\$B\$9:B11))),"")}</TD></TR><TR><TD>D10</TD><TD>{=IF(ROWS(\$A\$10)<=\$A\$1,INDEX(\$A\$3:\$A\$8,SMALL(IF(FREQUENCY(IF(\$A\$3:\$A\$8<>"",MATCH("~"&\$A\$3:\$A\$8&"",\$A\$3:\$A\$8,0)),ROW(\$A\$3:\$A\$8)-ROW(\$A\$3)+1),ROW(\$A\$3:\$A\$8)-ROW(\$A\$3)+1),ROWS(\$B\$9:B12))),"")}</TD></TR><TR><TD>A11</TD><TD>=COUNTIF(\$A\$2:\$A\$8,A10)</TD></TR><TR><TD>B11</TD><TD>=COUNTIF(\$A\$2:\$A\$8,B10)</TD></TR><TR><TD>C11</TD><TD>=COUNTIF(\$A\$2:\$A\$8,C10)</TD></TR><TR><TD>D11</TD><TD>=COUNTIF(\$A\$2:\$A\$8,D10)</TD></TR><TR><TD>A12</TD><TD>{=IF(ROWS(A\$12:A12)<=A\$11,INDEX(\$B\$3:\$B\$8,SMALL(IF(\$A\$3:\$A\$8=A\$10,ROW(\$B\$3:\$B\$8)-ROW(\$B\$3)+1),ROWS(A\$12:A12))),"")}</TD></TR><TR><TD>B12</TD><TD>{=IF(ROWS(B\$12:B12)<=B\$11,INDEX(\$B\$3:\$B\$8,SMALL(IF(\$A\$3:\$A\$8=B\$10,ROW(\$B\$3:\$B\$8)-ROW(\$B\$3)+1),ROWS(B\$12:B12))),"")}</TD></TR><TR><TD>C12</TD><TD>{=IF(ROWS(C\$12:C12)<=C\$11,INDEX(\$B\$3:\$B\$8,SMALL(IF(\$A\$3:\$A\$8=C\$10,ROW(\$B\$3:\$B\$8)-ROW(\$B\$3)+1),ROWS(C\$12:C12))),"")}</TD></TR><TR><TD>D12</TD><TD>{=IF(ROWS(D\$12:D12)<=D\$11,INDEX(\$B\$3:\$B\$8,SMALL(IF(\$A\$3:\$A\$8=D\$10,ROW(\$B\$3:\$B\$8)-ROW(\$B\$3)+1),ROWS(D\$12:D12))),"")}</TD></TR><TR><TD>A13</TD><TD>{=IF(ROWS(A\$12:A13)<=A\$11,INDEX(\$B\$3:\$B\$8,SMALL(IF(\$A\$3:\$A\$8=A\$10,ROW(\$B\$3:\$B\$8)-ROW(\$B\$3)+1),ROWS(A\$12:A13))),"")}</TD></TR><TR><TD>C13</TD><TD>{=IF(ROWS(C\$12:C13)<=C\$11,INDEX(\$B\$3:\$B\$8,SMALL(IF(\$A\$3:\$A\$8=C\$10,ROW(\$B\$3:\$B\$8)-ROW(\$B\$3)+1),ROWS(C\$12:C13))),"")}</TD></TR></TBODY></TABLE></TD></TR><TR><TD>Formula Array:
Produce enclosing { } by entering
formula with CTRL+SHIFT+ENTER!

</TD></TR></TBODY></TABLE>

#### Sparky

##### Board Regular
I had the same problem and before I posted the question I searched the message board and receved the answer in the second thread that I read.

So it does pay to search first.

#### shemayisroel

##### Well-known Member
Hi,

Sorry to bring up an old post.

Re my post # 4, instead of names in Column A, what if I had dates? How would I modify my formula say in A12 that is currently working but when you change the names to dates it's returning #NUM!

In A12

{=IF(ROWS(A\$12:A12)<=A\$11,INDEX(\$B\$3:\$B\$8,SMALL(IF(\$A\$3:\$A\$8=A\$10,ROW(\$B\$3:\$B\$8)-ROW(\$B\$3)+1),ROWS(A\$12:A12))),"")}

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: center">4</TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD>NAME</TD><TD style="TEXT-ALIGN: center">SUM</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD>01/01/09</TD><TD style="TEXT-ALIGN: center">333</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD>02/01/09</TD><TD style="TEXT-ALIGN: center">555</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD>07/01/09</TD><TD style="TEXT-ALIGN: center">777</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD>01/01/09</TD><TD style="TEXT-ALIGN: center">200</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD>07/01/09</TD><TD style="TEXT-ALIGN: center">400</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD>03/01/09</TD><TD style="TEXT-ALIGN: center">700</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="TEXT-ALIGN: center">01/01/09</TD><TD style="TEXT-ALIGN: center">02/01/09</TD><TD style="TEXT-ALIGN: center">07/01/09</TD><TD style="TEXT-ALIGN: center">03/01/09</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="TEXT-ALIGN: center">2</TD><TD style="TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: center">2</TD><TD style="TEXT-ALIGN: center">1</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="TEXT-ALIGN: center">333</TD><TD style="TEXT-ALIGN: center">555</TD><TD style="TEXT-ALIGN: center">777</TD><TD style="TEXT-ALIGN: center">700</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="TEXT-ALIGN: center">200</TD><TD></TD><TD style="TEXT-ALIGN: center">400</TD></TR></TBODY></TABLE>

##### MrExcel MVP
Hi,

Sorry to bring up an old post.

Re my post # 4, instead of names in Column A, what if I had dates? How would I modify my formula say in A12 that is currently working but when you change the names to dates it's returning #NUM!

In A12

{=IF(ROWS(A\$12:A12)<=A\$11,INDEX(\$B\$3:\$B\$8,SMALL(IF(\$A\$3:\$A\$8=A\$10,ROW(\$B\$3:\$B\$8)-ROW(\$B\$3)+1),ROWS(A\$12:A12))),"")}

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: center">4</TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD>NAME</TD><TD style="TEXT-ALIGN: center">SUM</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD>01/01/09</TD><TD style="TEXT-ALIGN: center">333</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD>02/01/09</TD><TD style="TEXT-ALIGN: center">555</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD>07/01/09</TD><TD style="TEXT-ALIGN: center">777</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD>01/01/09</TD><TD style="TEXT-ALIGN: center">200</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD>07/01/09</TD><TD style="TEXT-ALIGN: center">400</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD>03/01/09</TD><TD style="TEXT-ALIGN: center">700</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="TEXT-ALIGN: center">01/01/09</TD><TD style="TEXT-ALIGN: center">02/01/09</TD><TD style="TEXT-ALIGN: center">07/01/09</TD><TD style="TEXT-ALIGN: center">03/01/09</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="TEXT-ALIGN: center">2</TD><TD style="TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: center">2</TD><TD style="TEXT-ALIGN: center">1</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="TEXT-ALIGN: center">333</TD><TD style="TEXT-ALIGN: center">555</TD><TD style="TEXT-ALIGN: center">777</TD><TD style="TEXT-ALIGN: center">700</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="TEXT-ALIGN: center">200</TD><TD></TD><TD style="TEXT-ALIGN: center">400</TD></TR></TBODY></TABLE>
Dates should not make any difference at all and they don't...

#### shemayisroel

##### Well-known Member
Ignore me, so obvious - dates!!! Were not true dates.

#### gameover

##### Active Member
Hi All,

Sorry for bringing this topic again, but I have a question here.

I have an excel sheet with 2 sheets viz. sheet 1 and sheet 2. In both sheets there are 2 columns A and B. In sheet 1 I made a drop- down list (not filter) in column A, B, C, ...... with 100 values each, which are also present in column A of sheet 2.

What I need is whenever 1 choose a value from drop down list of column A of sheet1, a drop down list should be made to the corresponding cell in column B in sheet2. The values that has to be present in column B should be taken from sheet 2.

I couldn't get the answer from above posts. Can you plz help me out here?

#### gameover

##### Active Member
Hey I got it!!! Thanks