VLookup

[Memar]

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I am trying to use the VLookup function to get employees’ number of working hours per pay period. Since I want to get individual’s time, I have to look it up by name. Some of the Employees might not work on a specific project on certain pay periods. Thus it gives me N/A for those employees. The problem is I have a formula which calculates the total including Overhead and G&A. Currently I copy and paste the formula for individuals who only working on the specific project at the specific time. <o></o>
I just want to have the formula for all employees and not to get N/A to be able to use the other formula. Would you please let me know if there is a way to amend this formula? <o> </o>
<o> </o>
=VLOOKUP(E14,'[XXX.xls]XXX XXX'!$D$18:$G$24,4,FALSE)
<o> </o>
Thanks for your time and help.

 

[Jonmo1]

Welcome to the board..

The basic syntax is

=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))

Or if you have XL2007 or higher..

=IFERROR(VLOOKUP(...),"")

Hope that helps.

 

[Memar]

Thank you very much. It works with little modification.

 

[Uncle J]

Hello,

I am new to the board. I am having trouble with my vlookup giving me the incorrect data. I wanted it to return a date and I realized that it will return a number and I tried to then format it to a date, but it gives me a random date. Any thoughts?

I appreciate your time and efforts.