Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate and use cell value in formula
I have defined 16 ranges named Range00 to Range44.
Then I have two cells, one selects the first part, i.e Range0,Range1,Range2,Range3 & Range4 then the second selects 0,1,2,3 or 4 dependent on another cell value. I want to combine these two cell values and then use the result in a vlookup function. Can I do this ? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate and use cell value in formula
Yes, the INDIRECT function should work for you:
Let's say your first cell is A1 and second cell is A2, you'd use something like: =VLOOKUP(123,INDIRECT(A1 & A2),2,False) HTH, Elkar "gibbylinks" wrote: I have defined 16 ranges named Range00 to Range44. Then I have two cells, one selects the first part, i.e Range0,Range1,Range2,Range3 & Range4 then the second selects 0,1,2,3 or 4 dependent on another cell value. I want to combine these two cell values and then use the result in a vlookup function. Can I do this ? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate text cell and formula cell result | Excel Worksheet Functions | |||
Formula: copy/concatenate cell contents matching condition | Excel Discussion (Misc queries) | |||
Why does Concatenate formula show but not produce a cell result? | Excel Worksheet Functions | |||
how do i concatenate a string and cell formula and use a comma? | Excel Worksheet Functions | |||
Evaluating results of a concatenate formula, as a formula | Excel Worksheet Functions |