Vlookup Formula

[dmejia174]

Hello All,

If possible, i am needing some help in figuring out a formula to enter into cell D4 in the query sheet. The formula should do a lookup to give me the dollar amount from the TB sheet. I am trying to understand if there is a variance between the two sheets. The formula should hopefully look at two factors, the UNIT and the GL ACCOUNT. For example, if the UNIT Is 10004 and the GL ACCOUNT is 311001 - i would like to enter the formula into D4 to give me the dollar amount for the same UNIT and GL Account from the TB Sheet.

Hopefully this makes sense!
http://tb.xlsx
Please help!

Thanks!

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

(Take a look at the sumifS() function)