M
Margherita
Hi
I'm trying to do a VLOOKUP from two different sheets on a another workbook.
Can a person combine say for instance a logical function like OR together
with VLOOKUP?
E.g.
=OR(VLOOKUP(lookup_value,'[Register.xls]A3'!table_array,col_index_num,FALSE,VLOOKUP(lookup_value,'[Register.xls]K'!table_array,col_index_num,FALSE))
I've tried this, but it doesn't seem to work. I'm not sure what other
functions one could try to achieve this.
I'm trying to do a VLOOKUP from two different sheets on a another workbook.
Can a person combine say for instance a logical function like OR together
with VLOOKUP?
E.g.
=OR(VLOOKUP(lookup_value,'[Register.xls]A3'!table_array,col_index_num,FALSE,VLOOKUP(lookup_value,'[Register.xls]K'!table_array,col_index_num,FALSE))
I've tried this, but it doesn't seem to work. I'm not sure what other
functions one could try to achieve this.