Formula for extracting information from one worksheet's column to different worksheet giving blank result.
Excel for Microsoft 365 (desktop), version 2607, build 16.0
Golf stats workbook has one sheet called "Scores" that contains one row for each round for every round I've played, including course name in column A and date played in B. There is one sheet per course with the name of the course in both the tab and in A2 and one column per round played with the date in row 2. In the Scores sheet, column BC contains the color of the tees I played that day. I'm trying to get that color into the correct sheet and under the correct date in row 3 using the following formula, but getting blanks:
=IF(AND(Scores!$A$1:$A$2000=$A$2,Scores!$B$1:$B$2000=F$2),Scores!$BC$1:$BC$2000,"")
The goal: If the course sheet's course name in A2 matches the Score sheet's column A, AND the course sheet's date in row 2 matches the date in the Score sheet's column B, then put the color value in the Score sheets column BC in row 3 of the course sheet. Thank you!
[link] [comments]
Want to read more?
Check out the full article on the original site