Vlookup - picking from a formula.

[CAM]

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

 

[Gary Keramidas]

try something like this:

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

 

[CAM]

Thanks Gary,

Works great!

try something like this:

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