| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to use a table index from a formula
I have a function where I wish to choose my lookup table (I have several
range names defined for each of these tables) I have written a function which can compute the correct range name but when I use this in the formula =VLOOKUP(IF(AE8<0.37;0.37;AE8);(xplace(AU8));4;TRU E) I get an error. Possibly excel cannot compute xplace(AU8) correctly as a text value . Pls help Narendra |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make formula grow with the table | Excel Discussion (Misc queries) | |||
| Adding a formula to a pivot table | Excel Discussion (Misc queries) | |||
| table | Excel Discussion (Misc queries) | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Threaded Mode
