Hello,

I am using Excel 2007 I have a long GL account number and I only want to
pick up a certain account number. I use this in my formula (=MID(F4,5,4),
which works fine I get the number (8025), but here is my problem I try to
use VLookup based on the number 8025 (logical_test) it does not work. If I
remove the =MID(F4,5,4) from the cell and replace it with 8025 the Vlookup
works. I want to use my code =MID(F4,5,4), but the VLookup won't work. Is
there a work around solution or different way to code? Any tips will be
appreciated. Thank you in advance.

Cheers

try something like this:

=VLOOKUP(VALUE(D13),F4:H13,2)

--


Gary

"CAM" wrote in message
...
Hello,

I am using Excel 2007 I have a long GL account number and I only want to pick
up a certain account number. I use this in my formula (=MID(F4,5,4), which
works fine I get the number (8025), but here is my problem I try to use
VLookup based on the number 8025 (logical_test) it does not work. If I remove
the =MID(F4,5,4) from the cell and replace it with 8025 the Vlookup works. I
want to use my code =MID(F4,5,4), but the VLookup won't work. Is there a work
around solution or different way to code? Any tips will be appreciated. Thank
you in advance.

Cheers

Thanks Gary,

Works great!


"Gary Keramidas" <GKeramidasAtMsn.com wrote in message
...
try something like this:

=VLOOKUP(VALUE(D13),F4:H13,2)

--


Gary

"CAM" wrote in message
...
Hello,

I am using Excel 2007 I have a long GL account number and I only want to
pick up a certain account number. I use this in my formula
(=MID(F4,5,4), which works fine I get the number (8025), but here is my
problem I try to use VLookup based on the number 8025 (logical_test) it
does not work. If I remove the =MID(F4,5,4) from the cell and replace it
with 8025 the Vlookup works. I want to use my code =MID(F4,5,4), but the
VLookup won't work. Is there a work around solution or different way to
code? Any tips will be appreciated. Thank you in advance.

Cheers