Forum Discussion
Solved
Excel - check a number and refer in a column to another column
Hello. (IF-question) Desired forms should refer to (driver 1,2,3,4,5,6) on the individual line.
- By enter "1" in column "Q", the amount in "E" is required to copy to "S" associated driver 1...
I may not have explained it well, but this is the approach I was taking.
Thanks
It did not work :-(
See the attached file
Thank you in advance :-)
In cell Q5, you will want
=IF($O5=1,$E5,"")
In cell R5, you will want
=IF($O5=2,$E5,"")
and so on, until the first row of columns Q through your last column is filled in. Y ou can then copy down to fill in the other rows, and should give you what you want. Note that the value changes after the = .
Thanks, but It did not work :-(
Something I miss??
Thank you in advance :-)
See Attached Excel-file
I may not have explained it well, but this is the approach I was taking.