using multiple IF commands

[chrisjako]

=IF(MATCH(E:E,'TMC CSV Upload'!P$2:P$54,0),'Export To CSV'!Z$2,"misc",IF(MATCH(E:E,'TMC CSV Upload'!P$55:P$84,0),'Export To CSV'!Z$3,"misc",))

I'm trying to do a fill down so that cells if cells in P2:P54 match it returns Z2 or if P55:P84 match then it returns value of Z3

any anyone please help with the formula?

 

[oldbrewer]

let us say we are looking to find matches between A and B columns
in column C use this formula

=if(B2<>A2,"",if(row()<55,Z2,Z3))

 

[BarryL]

try:

=IF(ISNUMBER(MATCH(E:E,'TMC CSV Upload'!P$2:P$54,0)),'Export To CSV'!Z$2,IF(ISNUMBER(MATCH(E:E,'TMC CSV Upload'!P$55:P$84,0)),'Export To CSV'!Z$3,"misc"))

 

[olivierhbh]

Hi,

Would that work for you?

=IF(P2=E2,IF(ROW()<55,$Z$2,$Z$3), "")

What do you want to do with that "misc"?

Olivier.

 

[chrisjako]

try:

=IF(ISNUMBER(MATCH(E:E,'TMC CSV Upload'!P$2:P$54,0)),'Export To CSV'!Z$2,IF(ISNUMBER(MATCH(E:E,'TMC CSV Upload'!P$55:P$84,0)),'Export To CSV'!Z$3,"misc"))

BarryL you are truly AWESOME! - worked a treat I need to add about 40 more statements to this but tried the next and it worked too

May you have a blessed day - thank you all to who replied, this forum is amazing!