I need a formula that will search a worksheet "Source" for specific data
"account#"
and return data in the same row but in a different column "balance". The
data would populate a different worksheet (destination).

Example Source:
Account Balance
123 100
152 150
942 99

I need the formula to search through the account numbers for a specific
number and return the balance to the other sheet.
Notes:
The source data sheet has blank rows.
The source data is updated regularly.
New accounts may be added to the source data.


The offset function has worked but requires extra work as the source data
sheet must be open to make the destination fields fill in. Once the source
data sheet is closed or deleted the destination fields have error values.

I believe the DGET function may have the answer but can not figure out the
syntax.