| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell reference in vlookup not working | Excel Worksheet Functions | |||
| VLOOKUP using cell reference | Excel Worksheet Functions | |||
| How do I get the cell address of a VLOOKUP reference? | Excel Worksheet Functions | |||
| Using a cell reference of a sheet in Vlookup | Excel Worksheet Functions | |||
| use a cell to reference a range in a vlookup | Excel Discussion (Misc queries) | |||
Threaded Mode
