Vlookup of network username

sidsmot · May 13th, 2002, 07:17 PM

Hi, I have a page which prints from a macro that includes the username of the person logged in on a network. The usernames are staff nos and I am using VLookup to get the persons name. The formula below works fine except for a user not in the lookup list. This shows as #N/A. I would like it to print blank. Can anyone help please.

=VLOOKUP(K2,L2:N15,2,FALSE)
K2 = username (staff no.)
L2 - L15 = staff nos of people who mostly use this workbook
N2 - N15 = persons name

thanx
Sid

Yogi Anand · May 13th, 2002, 07:23 PM

Use
=if(isna(YourVlookupFormula),"",YourVlookupFormula)

sidsmot · May 13th, 2002, 07:29 PM

Yogi thx very much - works manifique!!
That was quick!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 07:17 PM	#1
sidsmot Board Regular Join Date: Apr 2002 Posts: 50	Hi, I have a page which prints from a macro that includes the username of the person logged in on a network. The usernames are staff nos and I am using VLookup to get the persons name. The formula below works fine except for a user not in the lookup list. This shows as #N/A. I would like it to print blank. Can anyone help please. =VLOOKUP(K2,L2:N15,2,FALSE) K2 = username (staff no.) L2 - L15 = staff nos of people who mostly use this workbook N2 - N15 = persons name thanx Sid

May 13th, 2002, 07:23 PM	#2
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Use =if(isna(YourVlookupFormula),"",YourVlookupFormula)

May 13th, 2002, 07:29 PM	#3
sidsmot Board Regular Join Date: Apr 2002 Posts: 50	Yogi thx very much - works manifique!! That was quick!