M
Maileen
Hi,
on sheet2, i have the following table
col1 col2 col3
A 1 10
A 2 11
B 1 20
B 2 25
C 1 30
C 2 32
....
on sheet1, i have the following table
col1 col2 col3
A 2
B 1
A 1
C 1
i would like in col3 the result of the search...something like
research on sheet 2 the couple sheet1:col1 and sheet1:col2
if found sheet1:col3 = result of research
this exist vis LOOKUP function, but it does not allow a research based on 2
parameter...
how can i do it ?
thanks a lot for help
Maileen
on sheet2, i have the following table
col1 col2 col3
A 1 10
A 2 11
B 1 20
B 2 25
C 1 30
C 2 32
....
on sheet1, i have the following table
col1 col2 col3
A 2
B 1
A 1
C 1
i would like in col3 the result of the search...something like
research on sheet 2 the couple sheet1:col1 and sheet1:col2
if found sheet1:col3 = result of research
this exist vis LOOKUP function, but it does not allow a research based on 2
parameter...
how can i do it ?
thanks a lot for help
Maileen