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

Using the address function to reference a cell. I want to return the contents of that cell on a different sheet.

Solved by T. B. in 19 mins

Hi Greetings, I want to match a reference cell with 3 different cells and return if matched by any of the 3 cells. Eg: Condition 1: A5 is the reference cell, if A5 = B5 then it should return "On track" Condition 2: If A5<>B5 , it should take reference cell as B5 and look up for the match below A5. i.e., A4,A3,A2,A1. If any one of the cell matches with B5 , it should return "slow" Condition 3:If A5<>B5 , it should take reference cell as B5 and look up for the match above A5. i.e., A6,A7,A8,A9. If any one of the cell matches with B5, it should return "Fast" Either through formula or VB Script

Solved by F. Y. in 26 mins

I need cell B8 to reference 4 cells and return an "x' if they have a's and b's in the 4 cells and if they do not then it will return a "-"

Solved by B. W. in 22 mins

b. If the value in cell H4 is greater than 0, the formula should return the value in J4 subtracted from the value in cell D5 multiplied by 12. Use a relative cell reference to cell J4 and an absolute cell reference to cell D5. (Hint: Use 12*$D$5-J4 as the is_true argument value in the formula.)

Solved by V. U. in 24 mins

I need a vlookup type formula to reference a column and row and return the value at that intersection. I need the formula to reference a given last name and match it to a column from colums D-O, then reference a given date and match it to a list of dates from row a10-a440. Then return the value or cell name at that intersection.

Solved by V. F. in 21 mins