Excel formula
Budget: $10 – $30 USD
I am looking for assistance with an Excel formula, specifically the VLOOKUP function.
Skills and experience required:
- Proficiency in Excel and knowledge of VLOOKUP function
- Experience working with datasets and applying formulas to them
Hello guys,
I need a simple excel formula to match the odds from cells H,I,J,K,L to cells AB,AC,AD,AE,AF.
The names of the Teams from cells C and D needs to match exactly the same as in columns P and Q,if it doesn't matches then the cell in P or D should be blank,like this match Al-Najma ,if the name in P 28 cell is Al Najma without - character then it should be blank cell P28 (as an example).
Date in cell F needs to match also with date in cell N.
When all those cells match exactly the same then the odds should show up in cells AB all the way to AF.
I have marked with different colors what should match exactly.
Skills and experience required:
- Proficiency in Excel and knowledge of VLOOKUP function
- Experience working with datasets and applying formulas to them
Hello guys,
I need a simple excel formula to match the odds from cells H,I,J,K,L to cells AB,AC,AD,AE,AF.
The names of the Teams from cells C and D needs to match exactly the same as in columns P and Q,if it doesn't matches then the cell in P or D should be blank,like this match Al-Najma ,if the name in P 28 cell is Al Najma without - character then it should be blank cell P28 (as an example).
Date in cell F needs to match also with date in cell N.
When all those cells match exactly the same then the odds should show up in cells AB all the way to AF.
I have marked with different colors what should match exactly.