Thread
:
Two condition IF
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
Two condition IF
Hi,
Am Fri, 11 Aug 2017 13:57:33 -0700 (PDT) schrieb
:
Using Excel 2007, I?m trying to use an If statement to return ?Y? or ?? against two conditions.
In tab titled ?PostMove?, I would like a formula which looks at B6 to get 6338016, then looks at I4 to get SR360. Using Vlookup perhaps look in the tab CD_Dump to return a Y because the two criteria match was found (6338016 & SR360). In J6, the formula would return ?? because SR374 is not one of the matches for 6338016. I would like to copy this formula across rows J to W.
Col B Col I Col J etc to Col W
Row OEM ID SR360 SR374
6 6338016
Tab titled ?CD_Dump? with 93945 rows
Col A B C D E F
SKU Flyer# s p description sr#
6338016 17 18 Seat SR360
6338016 17 18 Seat SR812
6338016 17 40 Seat SR698
6338016 17 18 Seat SR872
try:
=IF(ISNUMBER(MATCH($B6&I$5,CD_Dump!$A$2:$A$100&CD_ Dump!$E$2:$E$100,0)),"y","")
and insert the formula with CTRL+Shift+Enter
Regards
Claus B.
--
Windows10
Office 2016
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch