If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
second question - vlookup table_array reference listed
Thank you for the update. I have one last question in
regards to the original question listed below. When I reference a table in b6 that is in another file, the formula will not return a number unless the other file is open. Any idea how to correct this. Thank you -- James Dean. If anyone can help with this vlookup question I would appreciate your input. I am trying to place in the vlookup function (VLOOKUP(lookup_value,table_array,col_index_num,FA LSE), a cell reference in each of the parameters (i.e. vlookup (b5,b6,b7,false)) where the lookup_value is in b5, the table_array name is in b6, and the col_index is in b7. I can only get it to work with using cell references for the parameters b5 & b7. I have to put the actual parameter for b6 (table_array) in the formula itself. Any ideas how I can get it to take the table array from the referenced cell? Thank you -- James Dean .. |
Thread Tools | |
Display Modes | |
|
|