Excel Formula Expert - Excel VBA
Budget: $10 – $30 USD
We need some formula or VBA coding done to help sort some data in Excel.
Formula 1:
IF I2 matches the string in column C, then
print/display/return string from the same row of B into F2
print/display/return string from the same row of C into G2
print/display/return string from the same row of D into H2
------------
Formula 2:
Check to see if any word in I2 exists J2. If it exists, return a 1. If not present, return a 0 in L2
Check to see if any word in I2 exists K2. If it exists, return a 1. If not present, return a 0 in M2
Check attached spreadsheet for an example of the manual work.
Formula 1:
IF I2 matches the string in column C, then
print/display/return string from the same row of B into F2
print/display/return string from the same row of C into G2
print/display/return string from the same row of D into H2
------------
Formula 2:
Check to see if any word in I2 exists J2. If it exists, return a 1. If not present, return a 0 in L2
Check to see if any word in I2 exists K2. If it exists, return a 1. If not present, return a 0 in M2
Check attached spreadsheet for an example of the manual work.