VLookup and a Cell Reference
 

Hello,

I have cell locations in a Named Range table and am using VLookup to pulli a
specific cell location into another worksheet's formula. Here is my formula:

=IF(ISBLANK(F30), "" , "=" & (VLOOKUP('Line
Items'!B15,PoolPerCentLoc,3,FALSE)))

With this I get the value I want, =E$7 but as a string. It doesn't pull in
the value of cell E7. What am I missing?

Thanks in advance.

VLookup and a Cell Reference
 

Try it like this:

=IF(F30="","",INDIRECT(VLOOKUP('Line Items'!B15,PoolPerCentLoc,3,0)))


--
Biff
Microsoft Excel MVP


"Karen53" wrote in message
...
Hello,

I have cell locations in a Named Range table and am using VLookup to pulli
a
specific cell location into another worksheet's formula. Here is my
formula:

=IF(ISBLANK(F30), "" , "=" & (VLOOKUP('Line
Items'!B15,PoolPerCentLoc,3,FALSE)))

With this I get the value I want, =E$7 but as a string. It doesn't pull
in
the value of cell E7. What am I missing?

Thanks in advance.

VLookup and a Cell Reference
 

Thank you!

"T. Valko" wrote:

Try it like this:

=IF(F30="","",INDIRECT(VLOOKUP('Line Items'!B15,PoolPerCentLoc,3,0)))


--
Biff
Microsoft Excel MVP


"Karen53" wrote in message
...
Hello,

I have cell locations in a Named Range table and am using VLookup to pulli
a
specific cell location into another worksheet's formula. Here is my
formula:

=IF(ISBLANK(F30), "" , "=" & (VLOOKUP('Line
Items'!B15,PoolPerCentLoc,3,FALSE)))

With this I get the value I want, =E$7 but as a string. It doesn't pull
in
the value of cell E7. What am I missing?

Thanks in advance.

VLookup and a Cell Reference
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Karen53" wrote in message
...
Thank you!

"T. Valko" wrote:

Try it like this:

=IF(F30="","",INDIRECT(VLOOKUP('Line Items'!B15,PoolPerCentLoc,3,0)))


--
Biff
Microsoft Excel MVP


"Karen53" wrote in message
...
Hello,

I have cell locations in a Named Range table and am using VLookup to
pulli
a
specific cell location into another worksheet's formula. Here is my
formula:

=IF(ISBLANK(F30), "" , "=" & (VLOOKUP('Line
Items'!B15,PoolPerCentLoc,3,FALSE)))

With this I get the value I want, =E$7 but as a string. It doesn't
pull
in
the value of cell E7. What am I missing?

Thanks in advance.