PDA

View Full Version : [SOLVED] index match function & IF to exclude few values



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

mancubus
02-19-2016, 06:42 AM
check this out:

http://blog.contextures.com/archives/2012/07/12/check-multiple-criteria-with-excel-index-and-match/