Forum Discussion
Excel - check a number and refer in a column to another column
I may not have explained it well, but this is the approach I was taking.
Hello,
try this, starting in cell S4. I can't see if the first row of data is row 4, so, if it is another row, please adjust the row number.
=if($Q4=S$3,$E4,"")
Copy this formula across and down. Note how the $ sign is placed in front of the column letters for Q and E, so it will always look in column Q and E when copied across, but it will adjust S to T, to U, etc when copied across. Also note how the row number for S$3 has a $ sign in front of the row , so it will always look in row 3 when the formula is copied down.
In words, the formula says: If the number in column Q in the current row is the same as the number in row 3 of the current column, then get the value in column E of the current row, else return a blank.
Does that help?