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 wrote:
> Hi,
>
> Need Help on Vlook Up in Excel 2007:-
>
> A Case is assigned
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
