Re: Convert Range name in cell for VLookup

You'll need to use indirect(b1) where data is. I've done this recently at
work, but don't have the format for "data" handy here. Do a search on
queries on this board from "Barb R." and you should find it.

"ddate" <ddate@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E1A7CB1A-242A-4DDA-A2EF-CF900790C331@xxxxxxxxxxxxxxxx
>I wanted to create a vlookup with the range names in a cell so that it
>would
> be flexible.
>
> Example: current formula: vlookup(A1,data,1,false)
>
> type in cell B1 -> data
>
> new formula: vlookup(A1,B1,1,false) .....cannot figure out how to have
> the
> formula read as value in B1 as a range name instead of a value. Is there
> a
> formula that can convert it properly?
>
> Thanks.


.

Relevant Pages

  • Calculating # of Months B/T Dates
    ... I have a spreadsheet with dates in column F and column H. I want to format ... a cell to calculate the number of months that have lapsed between these two ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Change cell format based on condition.
    ... checked (each cell has it's own conditional format). ... > Norie's Profile: ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Date format
    ... >leave my cell as General it excepts the number but does not have the slashes. ... The formula would be (with your entry in A1): ... (depending on which format you decide to use for entry) ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Non-numeric Data
    ... You could enter the formula =VALUEin a spare column, Format the ... cell to Number with appropriate decimal places, ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Actual solution
    ... Then format the cells as text ... some cells still display the numeric string in scientific ... Selecting the cell shows that it's already correctly formatted. ... Microsoft Excel MVP ...
    (microsoft.public.excel)