here is what i want to do
Table is defined size 50x10
Rows: 50
Col: 10
i need to
"get value from a cell lets say b3 (not included in table)
compare it with table column 2 (vlookup only supports comparison with the left most column - not the desired column)
if true
get value of the table col 8
compare with the string
if true
get the value from column 6 and adds in C3"
according to me i think i might get what i want if
- i can get vlookup to compare with the desired column.
-or i can make tables inside the tables (i-e table depending on the main table)
{
like master table is defined 50x10
so i can define slave tables only defining column range from the master table (like col 5-8 of the master table or sheet)
but rows are same as of master table. (so i can change the size of master table (only rows) and every other Slave table resized automatically)
any help would be appreciated
Bookmarks