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

Hi, I need a formula that when given a date will search a specific row of dates to find the match, then in that dates column find a number (1) then in the row that the number is in, return the name that is in the first cell of that row. hope you can help.

Solved by F. H. in 11 mins

I need a formula to be able to return a number when the following conditions exist: Word A and Number B exist in the same row, Word C and Number D exist in the same row, etc, with about 10 rows of words and numbers that must be matched together, and no word can be used twice.

Solved by X. A. in 12 mins

I have a three tab excel file. I want to insert one number on page one and have it find that number on tab 2 and return the value in the thrid column of that row.

Solved by V. H. in 13 mins

i need a formula to return a specific number depending on the total amount in the adjacent cell. Example : if the number is 10000 or above, formula should return 200, if the number is between 7500 and 10000, formula should return 175, and for anything less than 7500, formula should return 0.

Solved by E. S. in 25 mins

I'm tyring ti work out how to do:
If there is a number in cell AD4 greater than 1, return what is in cell AQ4. But if the number in AQ4 is blank or 0 return a 1. If no number in AD4 return a blank

Solved by G. J. in 23 mins