apexRaiden
New Member
- Joined
- Oct 7, 2021
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
Hey everyone! First time poster. I've came across the site a bunch for answers, so I figured I'd bring by my first question...
I have a row of data with a 10 columns. I want to do an if(search to find "xxx" in one column and "####" in the other, and if it finds BOTH, to output XXX.
This is an example of what i currently have.
=IF(IFERROR(SEARCH("####",$K10)*SEARCH("XXX",$B10)>0,0),"XYZName",VLOOKUP($B3,'[XXXXXXXXX.xlsx]Auto Assign DB'!A:D,4,FALSE))
Please ignore any minor mistakes, this doesnt currently work but was the closest thing I could provide to give an idea of what im trying to accomplish...
IF this and that are found, label it this. IFERROR, vlookup the db.
I have a row of data with a 10 columns. I want to do an if(search to find "xxx" in one column and "####" in the other, and if it finds BOTH, to output XXX.
This is an example of what i currently have.
=IF(IFERROR(SEARCH("####",$K10)*SEARCH("XXX",$B10)>0,0),"XYZName",VLOOKUP($B3,'[XXXXXXXXX.xlsx]Auto Assign DB'!A:D,4,FALSE))
Please ignore any minor mistakes, this doesnt currently work but was the closest thing I could provide to give an idea of what im trying to accomplish...
IF this and that are found, label it this. IFERROR, vlookup the db.