software

I currently have my Vlookup stmnt as this:

=IF(E2=quot;quot;,quot;quot;,VLOOKUP(E2,'Code Descrip'!T$3:U$27,2,FALSE))

'Code Decrip' is the name of the worksheet
I need to add another range X$3:Y48
What is the proper syntax - I wasnt able to get it right after searching
online for it.
Thanks so much.

Hi lpj

Not quite clear what you want to achieve here?

Why not have everything in the same range?

Am I correct in guessing that, if you do not find a matching record in the
primary range, you then want to do a lookup in the secondary range? If so,
you will have to use an If(OR( statement, to first look at the primary range,
and then, if you do not find anything there, do a VLOOKUP in the secondary
range. You will therefore have to test the primary range for an error
condition, and if the error condition exists, then look at the secondary
range, else look at the primary range. Again, why not put the whole lot in
one range?

--
ve_2nd_at. Stilfontein, Northwest, South Africaquot;lpjquot; wrote:

gt; I currently have my Vlookup stmnt as this:
gt;
gt; =IF(E2=quot;quot;,quot;quot;,VLOOKUP(E2,'Code Descrip'!T$3:U$27,2,FALSE))
gt;
gt; 'Code Decrip' is the name of the worksheet
gt; I need to add another range X$3:Y48
gt; What is the proper syntax - I wasnt able to get it right after searching
gt; online for it.
gt; Thanks so much.

Thanks for the reply! The reason I can't put it all in the same range is bc
this is an existing worksheet (which can't be modified) and there are some
columns of data in btwn that shouldn't be referrenced - they could create
duplicates or give invalid results back.

quot;Kassiequot; wrote:

gt; Hi lpj
gt;
gt; Not quite clear what you want to achieve here?
gt;
gt; Why not have everything in the same range?
gt;
gt; Am I correct in guessing that, if you do not find a matching record in the
gt; primary range, you then want to do a lookup in the secondary range? If so,
gt; you will have to use an If(OR( statement, to first look at the primary range,
gt; and then, if you do not find anything there, do a VLOOKUP in the secondary
gt; range. You will therefore have to test the primary range for an error
gt; condition, and if the error condition exists, then look at the secondary
gt; range, else look at the primary range. Again, why not put the whole lot in
gt; one range?
gt;
gt; --
gt; ve_2nd_at. Stilfontein, Northwest, South Africa
gt;
gt;
gt; quot;lpjquot; wrote:
gt;
gt; gt; I currently have my Vlookup stmnt as this:
gt; gt;
gt; gt; =IF(E2=quot;quot;,quot;quot;,VLOOKUP(E2,'Code Descrip'!T$3:U$27,2,FALSE))
gt; gt;
gt; gt; 'Code Decrip' is the name of the worksheet
gt; gt; I need to add another range X$3:Y48
gt; gt; What is the proper syntax - I wasnt able to get it right after searching
gt; gt; online for it.
gt; gt; Thanks so much.

Duplicates or invalid values - to say the value of the lookup field could
exist in 2 cells (i.e. T3 and V3, I would only want the returned value for
T3 NOT V3). that's why i can't have an one entire range quot;Kassiequot; wrote:

gt; Hi lpj
gt;
gt; Not quite clear what you want to achieve here?
gt;
gt; Why not have everything in the same range?
gt;
gt; Am I correct in guessing that, if you do not find a matching record in the
gt; primary range, you then want to do a lookup in the secondary range? If so,
gt; you will have to use an If(OR( statement, to first look at the primary range,
gt; and then, if you do not find anything there, do a VLOOKUP in the secondary
gt; range. You will therefore have to test the primary range for an error
gt; condition, and if the error condition exists, then look at the secondary
gt; range, else look at the primary range. Again, why not put the whole lot in
gt; one range?
gt;
gt; --
gt; ve_2nd_at. Stilfontein, Northwest, South Africa
gt;
gt;
gt; quot;lpjquot; wrote:
gt;
gt; gt; I currently have my Vlookup stmnt as this:
gt; gt;
gt; gt; =IF(E2=quot;quot;,quot;quot;,VLOOKUP(E2,'Code Descrip'!T$3:U$27,2,FALSE))
gt; gt;
gt; gt; 'Code Decrip' is the name of the worksheet
gt; gt; I need to add another range X$3:Y48
gt; gt; What is the proper syntax - I wasnt able to get it right after searching
gt; gt; online for it.
gt; gt; Thanks so much.

Hi lpj

Try the following formula:

=IF(E2=quot;quot;,quot;quot;,IF(ISERROR(VLOOKUP('Code
Descrip'!T$3:U$27,0,FALSE)),VLOOKUP(E2,'Code
Descrip'!X$3:Y$48,2,FALSE),VLOOKUP(E2,'Code Descrip'!T$3:U$27,2,FALSE))

--
ve_2nd_at. Stilfontein, Northwest, South Africaquot;lpjquot; wrote:

gt; Thanks for the reply! The reason I can't put it all in the same range is bc
gt; this is an existing worksheet (which can't be modified) and there are some
gt; columns of data in btwn that shouldn't be referrenced - they could create
gt; duplicates or give invalid results back.
gt;
gt; quot;Kassiequot; wrote:
gt;
gt; gt; Hi lpj
gt; gt;
gt; gt; Not quite clear what you want to achieve here?
gt; gt;
gt; gt; Why not have everything in the same range?
gt; gt;
gt; gt; Am I correct in guessing that, if you do not find a matching record in the
gt; gt; primary range, you then want to do a lookup in the secondary range? If so,
gt; gt; you will have to use an If(OR( statement, to first look at the primary range,
gt; gt; and then, if you do not find anything there, do a VLOOKUP in the secondary
gt; gt; range. You will therefore have to test the primary range for an error
gt; gt; condition, and if the error condition exists, then look at the secondary
gt; gt; range, else look at the primary range. Again, why not put the whole lot in
gt; gt; one range?
gt; gt;
gt; gt; --
gt; gt; ve_2nd_at. Stilfontein, Northwest, South Africa
gt; gt;
gt; gt;
gt; gt; quot;lpjquot; wrote:
gt; gt;
gt; gt; gt; I currently have my Vlookup stmnt as this:
gt; gt; gt;
gt; gt; gt; =IF(E2=quot;quot;,quot;quot;,VLOOKUP(E2,'Code Descrip'!T$3:U$27,2,FALSE))
gt; gt; gt;
gt; gt; gt; 'Code Decrip' is the name of the worksheet
gt; gt; gt; I need to add another range X$3:Y48
gt; gt; gt; What is the proper syntax - I wasnt able to get it right after searching
gt; gt; gt; online for it.
gt; gt; gt; Thanks so much.

Try...

=IF(E2lt;gt;quot;quot;,VLOOKUP(E2,IF(ISNUMBER(MATCH(E2,'Code
Descrip'!T3:T27,0)),'Code Descrip'!T3:U27,'Code Descrip'!X3:Y48),2,0),quot;quot;)

Hope this helps!

In article gt;,
lpj gt; wrote:

gt; I currently have my Vlookup stmnt as this:
gt;
gt; =IF(E2=quot;quot;,quot;quot;,VLOOKUP(E2,'Code Descrip'!T$3:U$27,2,FALSE))
gt;
gt; 'Code Decrip' is the name of the worksheet
gt; I need to add another range X$3:Y48
gt; What is the proper syntax - I wasnt able to get it right after searching
gt; online for it.
gt; Thanks so much.

Hi Kassis,

I this a typo on the first line?

gt;=IF(E2=quot;quot;,quot;quot;,IF(ISERROR(VLOOKUP('Code
gt;Descrip'!T$3:U$27,0,FALSE)),VLOOKUP(E2,'Code
gt;Descrip'!X$3:Y$48,2,FALSE),VLOOKUP(E2,'Code Descrip'!T$3:U$27,2,FALSE))

Should be

=IF(E2=quot;quot;,quot;quot;,IF(ISERROR(VLOOKUP(E2,'Code
etc...

Regards,
Howard

quot;lpjquot; gt; wrote in message
...
gt;I currently have my Vlookup stmnt as this:
gt;
gt; =IF(E2=quot;quot;,quot;quot;,VLOOKUP(E2,'Code Descrip'!T$3:U$27,2,FALSE))
gt;
gt; 'Code Decrip' is the name of the worksheet
gt; I need to add another range X$3:Y48
gt; What is the proper syntax - I wasnt able to get it right after searching
gt; online for it.
gt; Thanks so much.
Thanks so much - to all of you! I really appreciate it!

quot;Kassiequot; wrote:

gt; Hi lpj
gt;
gt; Try the following formula:
gt;
gt; =IF(E2=quot;quot;,quot;quot;,IF(ISERROR(VLOOKUP('Code
gt; Descrip'!T$3:U$27,0,FALSE)),VLOOKUP(E2,'Code
gt; Descrip'!X$3:Y$48,2,FALSE),VLOOKUP(E2,'Code Descrip'!T$3:U$27,2,FALSE))
gt;
gt; --
gt; ve_2nd_at. Stilfontein, Northwest, South Africa
gt;
gt;
gt; quot;lpjquot; wrote:
gt;
gt; gt; Thanks for the reply! The reason I can't put it all in the same range is bc
gt; gt; this is an existing worksheet (which can't be modified) and there are some
gt; gt; columns of data in btwn that shouldn't be referrenced - they could create
gt; gt; duplicates or give invalid results back.
gt; gt;
gt; gt; quot;Kassiequot; wrote:
gt; gt;
gt; gt; gt; Hi lpj
gt; gt; gt;
gt; gt; gt; Not quite clear what you want to achieve here?
gt; gt; gt;
gt; gt; gt; Why not have everything in the same range?
gt; gt; gt;
gt; gt; gt; Am I correct in guessing that, if you do not find a matching record in the
gt; gt; gt; primary range, you then want to do a lookup in the secondary range? If so,
gt; gt; gt; you will have to use an If(OR( statement, to first look at the primary range,
gt; gt; gt; and then, if you do not find anything there, do a VLOOKUP in the secondary
gt; gt; gt; range. You will therefore have to test the primary range for an error
gt; gt; gt; condition, and if the error condition exists, then look at the secondary
gt; gt; gt; range, else look at the primary range. Again, why not put the whole lot in
gt; gt; gt; one range?
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; ve_2nd_at. Stilfontein, Northwest, South Africa
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;lpjquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I currently have my Vlookup stmnt as this:
gt; gt; gt; gt;
gt; gt; gt; gt; =IF(E2=quot;quot;,quot;quot;,VLOOKUP(E2,'Code Descrip'!T$3:U$27,2,FALSE))
gt; gt; gt; gt;
gt; gt; gt; gt; 'Code Decrip' is the name of the worksheet
gt; gt; gt; gt; I need to add another range X$3:Y48
gt; gt; gt; gt; What is the proper syntax - I wasnt able to get it right after searching
gt; gt; gt; gt; online for it.
gt; gt; gt; gt; Thanks so much.

Thanks so much - to all of you! I really appreciate it!

quot;Domenicquot; wrote:

gt; Try...
gt;
gt; =IF(E2lt;gt;quot;quot;,VLOOKUP(E2,IF(ISNUMBER(MATCH(E2,'Code
gt; Descrip'!T3:T27,0)),'Code Descrip'!T3:U27,'Code Descrip'!X3:Y48),2,0),quot;quot;)
gt;
gt; Hope this helps!
gt;
gt; In article gt;,
gt; lpj gt; wrote:
gt;
gt; gt; I currently have my Vlookup stmnt as this:
gt; gt;
gt; gt; =IF(E2=quot;quot;,quot;quot;,VLOOKUP(E2,'Code Descrip'!T$3:U$27,2,FALSE))
gt; gt;
gt; gt; 'Code Decrip' is the name of the worksheet
gt; gt; I need to add another range X$3:Y48
gt; gt; What is the proper syntax - I wasnt able to get it right after searching
gt; gt; online for it.
gt; gt; Thanks so much.
gt;

Thanks so much - to all of you! I really appreciate it!

quot;L. Howard Kittlequot; wrote:

gt; Hi Kassis,
gt;
gt; I this a typo on the first line?
gt;
gt; gt;=IF(E2=quot;quot;,quot;quot;,IF(ISERROR(VLOOKUP('Code
gt; gt;Descrip'!T$3:U$27,0,FALSE)),VLOOKUP(E2,'Code
gt; gt;Descrip'!X$3:Y$48,2,FALSE),VLOOKUP(E2,'Code Descrip'!T$3:U$27,2,FALSE))
gt;
gt; Should be
gt;
gt; =IF(E2=quot;quot;,quot;quot;,IF(ISERROR(VLOOKUP(E2,'Code
gt; etc...
gt;
gt; Regards,
gt; Howard
gt;
gt; quot;lpjquot; gt; wrote in message
gt; ...
gt; gt;I currently have my Vlookup stmnt as this:
gt; gt;
gt; gt; =IF(E2=quot;quot;,quot;quot;,VLOOKUP(E2,'Code Descrip'!T$3:U$27,2,FALSE))
gt; gt;
gt; gt; 'Code Decrip' is the name of the worksheet
gt; gt; I need to add another range X$3:Y48
gt; gt; What is the proper syntax - I wasnt able to get it right after searching
gt; gt; online for it.
gt; gt; Thanks so much.
gt;
gt;
gt;