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