“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I would like a coloured cell in excel to show a number for example
a green cell would show the number 3
a blue cell would show the number 2
etc.

Solved by C. C. in 27 mins

Situation:
Trying to find the right VLOOKUP formula combined with IF. Data is coming from a table in another sheet but in the same file. Tried this formula but it doesn't work.
My concern, if the input/encoded data in cell G770670 can be found in:
Column 1, it will show CL650 in cell X770670
Column 2, it will show G5000 in cell X770670
Column 3, it will show G6000 in cell X770670
Column 4, it will show G7000 in cell X770670
Column 5, it will show Airbus in cell X770670

Solved by S. U. in 21 mins

Calculating Current Age: Formula Hi. I have the date of birth in Q2. I'd like to show the current age in Cell R2. Can you please show me the formula?

Solved by E. D. in 21 mins

I need a formula that compares three cells. ie if either cell ab2 or cell ac2 = cell ai2 then show me a zero, else show me the contents of cell ai2

Solved by F. Y. in 15 mins

I need a formula using if formula. In one cell it is, 68 - 79 (L) and in the next cell I need a formula to show a "-1" if there is an (L)

Solved by I. H. in 12 mins