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