| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula range
is there any way to make A2 in the formula a function of a cell value?
=VLOOKUP($B$1,A2:D1969,3,FALSE) Example: if F1 = the value of: "A50" So the formula in A1 would be: =VLOOKUP($B$1,A50:D1969,3,FALSE) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula range
Hi
Try =VLOOKUP($B$1,INDIRECT("'"&F1&"'!:D1969"),3,FALSE) Note the quotes " ' "&F1& " ' !:D1969" -- Regards Roger Govier "ADK" wrote in message ... is there any way to make A2 in the formula a function of a cell value? =VLOOKUP($B$1,A2:D1969,3,FALSE) Example: if F1 = the value of: "A50" So the formula in A1 would be: =VLOOKUP($B$1,A50:D1969,3,FALSE) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula range
I don/t think the ' and ! should be there.
This is a cell reference, not a sheet reference Is there a benefit, I am not aware of? "Roger Govier" wrote: Hi Try =VLOOKUP($B$1,INDIRECT("'"&F1&"'!:D1969"),3,FALSE) Note the quotes " ' "&F1& " ' !:D1969" -- Regards Roger Govier "ADK" wrote in message ... is there any way to make A2 in the formula a function of a cell value? =VLOOKUP($B$1,A2:D1969,3,FALSE) Example: if F1 = the value of: "A50" So the formula in A1 would be: =VLOOKUP($B$1,A50:D1969,3,FALSE) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula range
Hi,
Here is a slightly simplier formula: =VLOOKUP($B$1,INDIRECT(F1&":D1969"),3,FALSE) -- Cheers, Shane Devenshire "ADK" wrote: is there any way to make A2 in the formula a function of a cell value? =VLOOKUP($B$1,A2:D1969,3,FALSE) Example: if F1 = the value of: "A50" So the formula in A1 would be: =VLOOKUP($B$1,A50:D1969,3,FALSE) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula range
You are quite correct. My mistake.
So used to dealing with sheets, I type it automatically<g -- Regards Roger Govier "bj" wrote in message ... I don/t think the ' and ! should be there. This is a cell reference, not a sheet reference Is there a benefit, I am not aware of? "Roger Govier" wrote: Hi Try =VLOOKUP($B$1,INDIRECT("'"&F1&"'!:D1969"),3,FALSE) Note the quotes " ' "&F1& " ' !:D1969" -- Regards Roger Govier "ADK" wrote in message ... is there any way to make A2 in the formula a function of a cell value? =VLOOKUP($B$1,A2:D1969,3,FALSE) Example: if F1 = the value of: "A50" So the formula in A1 would be: =VLOOKUP($B$1,A50:D1969,3,FALSE) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula range
Thanks...this one worked great!
"ShaneDevenshire" wrote in message ... Hi, Here is a slightly simplier formula: =VLOOKUP($B$1,INDIRECT(F1&":D1969"),3,FALSE) -- Cheers, Shane Devenshire "ADK" wrote: is there any way to make A2 in the formula a function of a cell value? =VLOOKUP($B$1,A2:D1969,3,FALSE) Example: if F1 = the value of: "A50" So the formula in A1 would be: =VLOOKUP($B$1,A50:D1969,3,FALSE) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a range name in formula | Excel Discussion (Misc queries) | |||
| conditional formula: sum a range if text present in another range | Excel Discussion (Misc queries) | |||
| formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
| Formula for a new range..... | Excel Discussion (Misc queries) | |||
| Sum Formula that excludes other sum formula in range | Excel Worksheet Functions | |||
Linear Mode
