Lookup Help

[Alex O]

I need a formula that will look at AH and for each ID# return the corresponding value in AI. For example ID# AO3N3J would return a value of SYR/11-1340, SYR/12-2806.5 and AOVYF2 would return KC/11-292.
I've tried VLOOKUP but it only returns the first match.

Any help is appreciated!

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 102px"><COL style="WIDTH: 121px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>AH</TD><TD>AI</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri">A0RK6K</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; FONT-SIZE: 9pt">INS/11-2640</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri">800882</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; FONT-SIZE: 9pt">SDL/11-182.5</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: left; BACKGROUND-COLOR: #99cc00; FONT-FAMILY: Calibri">A03N3J</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; FONT-SIZE: 9pt">SYR/11-1340</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: left; BACKGROUND-COLOR: #99cc00; FONT-FAMILY: Calibri">A03N3J</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; FONT-SIZE: 9pt">SYR/12-2806.5</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri">A0VYF2</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; FONT-SIZE: 9pt">KC/11-292</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri">A0W282</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; FONT-SIZE: 9pt">KC/11-292</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri">A03502</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; FONT-SIZE: 9pt">CMB/10-142</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: left; BACKGROUND-COLOR: #99cc00; FONT-FAMILY: Calibri">A0LD59</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; FONT-SIZE: 9pt">ZAN/10-256.79</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: left; BACKGROUND-COLOR: #99cc00; FONT-FAMILY: Calibri">A0LD59</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; FONT-SIZE: 9pt">ZAN/11-645</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri">A0WJB0</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Calibri; FONT-SIZE: 9pt">MRF/11-382</TD></TR></TBODY></TABLE>

 

[markmzz]

Maybe this (array formula - use Ctrl+Shift+Enter and not only Enter):

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">A0RK6K</td><td style=";">INS/11-2640</td><td style="text-align: right;;"></td><td style="background-color: #C5D9F1;;">A03N3J</td><td style="background-color: #FFFF00;;">SYR/12-2806.5</td><td style="background-color: #FFFF00;;">SYR/11-1340</td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">800882</td><td style=";">SDL/11-182.5</td><td style="text-align: right;;"></td><td style="background-color: #C5D9F1;;">A0VYF2</td><td style="background-color: #FFFF00;;">KC/11-292</td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">A03N3J</td><td style=";">SYR/11-1340</td><td style="text-align: right;;"></td><td style="background-color: #C5D9F1;;">A0LD59</td><td style="background-color: #FFFF00;;">ZAN/11-645</td><td style="background-color: #FFFF00;;">ZAN/10-256.79</td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td><td style="background-color: #FFFF00;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">A03N3J</td><td style=";">SYR/12-2806.5</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">A0VYF2</td><td style=";">KC/11-292</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">A0W282</td><td style=";">KC/11-292</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style=";">A03502</td><td style=";">CMB/10-142</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style=";">A0LD59</td><td style=";">ZAN/10-256.79</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">A0LD59</td><td style=";">ZAN/11-645</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style=";">A0WJB0</td><td style=";">MRF/11-382</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet3</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Array Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">E1</th><td style="text-align:left">{=INDEX(<font color="Blue">IF(<font color="Red">$D1=$A$1:$A$10,$B$1:$B$10,""</font>),LARGE(<font color="Red">(<font color="Green">$D1=$A$1:$A$10</font>)*(<font color="Green">ROW(<font color="Purple">$A$1:$A$10</font>)-ROW(<font color="Purple">$A$1</font>)+1</font>),COLUMNS(<font color="Green">$E:E</font>)</font>)</font>)}</td></tr></tbody></table><b>Entered with Ctrl+Shift+Enter.</b> If entered correctly, Excel will surround with curly braces {}.
<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />
Markmzz

 

[T. Valko]

I need a formula that will look at AH and for each ID# return the corresponding value in AI. For example ID# AO3N3J would return a value of SYR/11-1340, SYR/12-2806.5 and AOVYF2 would return KC/11-292.
I've tried VLOOKUP but it only returns the first match.

Any help is appreciated!

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 102px"><COL style="WIDTH: 121px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>AH</TD><TD>AI</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-FAMILY: Calibri; TEXT-ALIGN: left">A0RK6K</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: left">INS/11-2640</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-FAMILY: Calibri; TEXT-ALIGN: left">800882</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: left">SDL/11-182.5</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-FAMILY: Calibri; BACKGROUND-COLOR: #99cc00; TEXT-ALIGN: left">A03N3J</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: left">SYR/11-1340</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-FAMILY: Calibri; BACKGROUND-COLOR: #99cc00; TEXT-ALIGN: left">A03N3J</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: left">SYR/12-2806.5</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-FAMILY: Calibri; TEXT-ALIGN: left">A0VYF2</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: left">KC/11-292</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-FAMILY: Calibri; TEXT-ALIGN: left">A0W282</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: left">KC/11-292</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-FAMILY: Calibri; TEXT-ALIGN: left">A03502</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: left">CMB/10-142</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-FAMILY: Calibri; BACKGROUND-COLOR: #99cc00; TEXT-ALIGN: left">A0LD59</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: left">ZAN/10-256.79</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-FAMILY: Calibri; BACKGROUND-COLOR: #99cc00; TEXT-ALIGN: left">A0LD59</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: left">ZAN/11-645</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-FAMILY: Calibri; TEXT-ALIGN: left">A0WJB0</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Calibri; TEXT-ALIGN: left">MRF/11-382</TD></TR></TBODY></TABLE>

See this...

VLOOKUP with multiple returns

http://www.mrexcel.com/forum/showpost.php?p=2696961&postcount=3

 

[Alex O]

These suggestions are helpful, but I need to have the values returned in a single string. The returned value is used in a seperate report that requires the values be together. Am I not understanding how the recommended solution will accomplish that??

thanks

 

[markmzz]

Try this function and tell us if it work.

Note: I do only fell tests with this function.

Option Explicit
Function VLookRept(Look_Value As Variant, _
        Tble_Array As Range, Col_num As Integer)
    Dim myRow As Range
    Dim myReturn As String
 
    Application.Volatile True
 
    For Each myRow In Tble_Array.Rows
        If myRow.Columns(1).Value = Look_Value Then
            myReturn = myReturn & myRow.Columns(Col_num).Value & ", "
        End If
    Next myRow
 
    VLookRept = Mid(myReturn, 1, Len(myReturn) - 2)
End Function

Markmzz

 

[Alex O]

markmzz - I'm not sure I understand how to use your function. Care to provide a cursory explination?

thanks

 

[markmzz]

markmzz - I'm not sure I understand how to use your function. Care to provide a cursory explination?

thanks

Alex,

Do the following:

Copy the code below.

Option Explicit
Function VLookRept(Look_Value As Variant, _
        Tble_Array As Range, Col_num As Integer)
    Dim myRow As Range
    Dim myReturn As String
 
    Application.Volatile True
 
    For Each myRow In Tble_Array.Rows
        If myRow.Columns(1).Value = Look_Value Then
            myReturn = myReturn & myRow.Columns(Col_num).Value & ", "
        End If
    Next myRow
 
    VLookRept = Mid(myReturn, 1, Len(myReturn) - 2)
End Function

Then press Alt + F11 to Microsoft Visual Basic window appears.

Open the Insert menu and choose Module.

Now paste the previously copied code, close the window in Microsoft Visual Basic and save your workbook.

Afterwards, just use the function in your worksheet. See this:

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">A0RK6K</td><td style=";">INS/11-2640</td><td style="text-align: right;;"></td><td style="background-color: #C5D9F1;;">A03N3J</td><td style=";">SYR/11-1340, SYR/12-2806.5</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">800882</td><td style=";">SDL/11-182.5</td><td style="text-align: right;;"></td><td style="background-color: #C5D9F1;;">A0VYF2</td><td style=";">KC/11-292</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">A03N3J</td><td style=";">SYR/11-1340</td><td style="text-align: right;;"></td><td style="background-color: #C5D9F1;;">A0LD59</td><td style=";">ZAN/10-256.79, ZAN/11-645</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">A03N3J</td><td style=";">SYR/12-2806.5</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">A0VYF2</td><td style=";">KC/11-292</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">A0W282</td><td style=";">KC/11-292</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style=";">A03502</td><td style=";">CMB/10-142</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style=";">A0LD59</td><td style=";">ZAN/10-256.79</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">A0LD59</td><td style=";">ZAN/11-645</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style=";">A0WJB0</td><td style=";">MRF/11-382</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet2</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">E1</th><td style="text-align:left">=VLookRept(<font color="Blue">D1,A$1:B$10,2</font>)</td></tr></tbody></table></td></tr></table><br />
Markmzz

 

[Alex O]

Very nice! Thats exactly what I was looking for.

Thanks

 

[markmzz]

Very nice! Thats exactly what I was looking for.

Thanks

Alex,

I'm happy for your problem was solved.

And thank you for the feedback.

Markmzz