View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Afolabi Afolabi is offline
external usenet poster
 
Posts: 7
Default lookup for criteria from either of 2 worksheets.

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?