VLOOKUP formula

R

Rallie

I am using a VLOOKUP formula in a sheet that is used for Employee Data Entry.
I have used it so that I do not have to enter the Employer and Trade once I
pick an employee from a drop down box.

The formula works when I have selected an employee from the list but when
the cell (say I2) the formula in cell J2 & K2 show up as #N/A until I have
selected an employee.

I need this not to show up becuase it is stuffing up the rest of my formulas
and calculations for the wages.

The formula that I have used is :
=VLOOKUP(I8,'Employee''s'!$B$2:$J$999,2,FALSE)
So the way the I worked it is if I8 equals anything in B2:J999 it shows the
value in row 2 of my employee table on the Employee worksheet but it shows
the #N/A if anything I8 is blank.
 
R

Rallie

Hi Mike,

Thanks for the reply.

I copied the formula over and it gets ride of the #N/A but it the will not
show up the information from row 2 for who his employer is.

Cheers.
Ral
 
M

Mike H

Hi,

The only thing I changed in your formula was the sheet name, to save me
creating a sheet of that name. Check I've put it back in correctly. Also
check your data for rogue spaces.

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top