Help with formula

Sandyg - Aug 31, 2010 at 09:35 AM
 Blocked Profile - Sep 6, 2010 at 07:17 AM

I am trying to create a fax coversheet that autofills in a specific cell the data that correlates to a particular name selected from a drop down. The workbook consists of two worksheets. One is the fax cover sheet (form,) and the other contains name, fax, and phone. I keep getting an #N/A error using VLOOKUP. Does anyone have any suggestions?

Thank you!

1 response

Blocked Profile
Sep 6, 2010 at 07:17 AM
Dear Sir,

This normally shows up when the value is an non available one. Please check well which of the values are not correct and remove it.

Thanks in advance.