I'll assume that you're attempting to lookup a value in a datalist on
Sheet1,
And if it's not found there, then lookup the *same* value in a datalist on
Sheet2,
and where this lookup formula and the value to lookup could be situated in
Sheet3.

Datalists on Sheets 1 & 2 have similar location references.
A1 to D50,
The only difference is the column index of the value to return.
Column D from Sheet1, and Column C from Sheet2.

=IF(ISNA(MATCH(E1,Sheet1!A1:A50,0)),IF(ISNA(MATCH( E1,Sheet2!A1:A50,0)),"No
Match",VLOOKUP(E1,Sheet2!A1:D50,3,0)),VLOOKUP(E1,S heet1!A1:D50,4,0))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Afolabi" wrote in message
...

Thanks for the attempt, I actually 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?