Like anything else, how you do will depend on what you already know. There's more gold in the West now than has already been taken out, and if you've got the prospecting skills you'll probably do fine.
Now for the bad news: if you haven't done some of what you plan on doing already, you're in for some rough times I think.
That said, I wish you well. Chug and Red will show you a good time in Vancouver.
But if you really want some good gold, be sure to hit the extreme southwestern corner of Oregon along the coast: good gold and platinum in black sand deposits there. If you already own a dredge that you can run in salt water through, that site alone may pay for your trip. In the 1930's during the Depression this area was worked extensively for gold in an area that the miner's cursed soundly because the platinum (then worth $20/ounce) would clog their riffles, allowing the fine gold to flow out the back. Southern Oregon also had the only hard-rock platinum mine in the United States. Be sure to take a strong magnet with you to this area, to separate out the ilmenite, magnetite and monzanite from the black sand concentrates. It's hard work. But the way metal prices are going, even those minerals may start to have some economic consequences for someone salting a gold-panning display at county fairs or local markets.
There is a way to make a living at this: explore the possibilities!