lookup for criteria from either of 2 worksheets.

G

Guest

I need vlookup to look up some common
criteria from EITHER of 2 different worksheets and return specified values
(in identified columns) to a 3rd worksheet.

I actually have the 1st worksheet containing COST of a couple of assets, and
the 2nd worksheet containing DEPRECIATION on the same asset. I have the 3rd
worksheet called BUDGET where I want to pull the COST or DEPRECIATION (but on
different lines)on these assets to.

Any help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Matching data from one worksheet to another. 3
simultaneous scrolling two different worksheets 3
Vlookup across multiple worksheets 2
i have about 100 worksheets, how do i "lookup" multiple criteria 8
Delete Row Containing "x" in ColumnA in 2 Worksheets 1
How to get a list from one worksheet to another. 1
Merging data from different worksheets 1
Making 1 Pivot chart from 3 different worksheets. 4

Top