Dear Praskandan,
You can use Global Vlookup
Example:
=Iferror(Vlookup for Person 1,iferror(Vlookup for person 2,N/A))
Hope it will help to you.
otherwise
Send sample.
On Tue, Jul 24, 2012 at 4:21 PM, Praskandan pras...@gmail.com wrote:
Hi,
Need Help on Vlook Up in Excel 2007:-
A Case
Hi,
Need Help on Vlook Up in Excel 2007:-
A Case is assigned to Person 1 (Column B) ...As a back up it is sometimes
assigned to Person 2 (Column C)
So if Case ID is in Column A , there is always name of Person in Column B.
But only some cases are Assigned Person 2 in Column C.
I want to lookup