aravindhan_3
02-17-2016, 03:16 AM
Hi,
I have a data in sheet 1 like country, product ID , description & price
in sheet 1 I am doing the index match function to get product Id based on price
example
in sheet 2 B1 I have this formula
=index(Sheet1A: D,match(A1,D: D,0),1) this is working fine
now I want to perform this excluding few countries in column B , I have typed out say 5 country names colum C
so my formula should read something like
if sheet1B:B<> values in column sheet2 C2:C6, then do =index(Sheet1A: D,match(A1,D: D,0),1).
not sure if am explaining correctly.
as of now I am filtering and deleting those countries data and doing this index match.
can someone help me plz
regards
Arvind
I have a data in sheet 1 like country, product ID , description & price
in sheet 1 I am doing the index match function to get product Id based on price
example
in sheet 2 B1 I have this formula
=index(Sheet1A: D,match(A1,D: D,0),1) this is working fine
now I want to perform this excluding few countries in column B , I have typed out say 5 country names colum C
so my formula should read something like
if sheet1B:B<> values in column sheet2 C2:C6, then do =index(Sheet1A: D,match(A1,D: D,0),1).
not sure if am explaining correctly.
as of now I am filtering and deleting those countries data and doing this index match.
can someone help me plz
regards
Arvind