I would like to compare two columns from two different worksheets. In this case, I have a cell at B2 in sheet 1, and if the description of this cell is the same as the description of any cell in sheet 2, the cell should display the content of a cell in sheet 1 column G.
This is unclear, but if I understand what you are saying, you will want something that looks similar to this
The way that works is
The "$" means if you copy the function down, it will stay in that specific cell for the comparison. The =ROWcolumn should be pointed to your cell you want the contents of if the function is true in $1. "False" is just the value spit out if $1 is false (you could, of course, just do "" for it to be blank).
If you make your question clear with examples, I could target it more - but that should get you off to a start.