#1   Report Post  
Old October 28th 04, 01:53 PM
Pam Coleman
 
Posts: n/a
Default vlookup

Can you have a vlookup if my database information is in column h and i. Does
it have to be in col a? On my inj worksheet in column c is emp numbers and
col d is blank, I want to match the emp# in col c (inj ws) to the emp
worksheet in col h, get the emp name in col I and bring it back to col d on
my inj ws.
My formula is: (On the injury ws) in cell d2:
=vlookup(c2,'empdatabase'h2:i1709,2)
(after c2, I click on the emp ws and excel puts this in.)
I keep getting a #n/a error, I sorted only col A on the emp ws. which is a
date. Please help

  #2   Report Post  
Old October 28th 04, 03:11 PM
Frank Kabel
 
Posts: n/a
Default

Hi
try:
=vlookup(c2,'empdatabase'!$h$2:$i$1709,2,0)

"Pam Coleman" wrote:

Can you have a vlookup if my database information is in column h and i. Does
it have to be in col a? On my inj worksheet in column c is emp numbers and
col d is blank, I want to match the emp# in col c (inj ws) to the emp
worksheet in col h, get the emp name in col I and bring it back to col d on
my inj ws.
My formula is: (On the injury ws) in cell d2:
=vlookup(c2,'empdatabase'h2:i1709,2)
(after c2, I click on the emp ws and excel puts this in.)
I keep getting a #n/a error, I sorted only col A on the emp ws. which is a
date. Please help



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup finds a blank, but returns a zero - HELP! flummoxed Excel Discussion (Misc queries) 6 January 18th 05 03:15 PM
Vlookup Syntax Error YV New Users to Excel 9 December 23rd 04 05:28 PM
Vlookup Question Jeff Excel Discussion (Misc queries) 2 December 2nd 04 02:40 PM
Need help with modifying VLookUp Tom Excel Discussion (Misc queries) 4 December 2nd 04 12:44 AM
Vlookup with VBA Jeff Excel Discussion (Misc queries) 8 December 1st 04 02:41 PM


All times are GMT +1. The time now is 05:49 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017