VLookup and a Cell Reference

G

Guest

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.
 
T

T. Valko

Try it like this:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Value of a Cell in the Range Reference in VLOOKUP 1
Vlookup and return sheet name also 2
VLOOKUP return cell location and hyperlink 0
vlookup error 3
VLookup vs. Match/Index 6
Vlookup - using a cell to reference a named array 3
Searching the formula (not the value) for a text string 1
Vlookup & relative cell reference? 2

Top