Help for a newcomer needed please.

[kins]

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Firstly, I am new to the forum, so hello.<o></o>
<o> </o>
<o> </o>
Secondly, and most importantly, I would like some help please. I am trying to write a formula in Excel but am have a little difficulty. I have tried ‘IF’ statements and also ‘Vlookups’ and ‘IF’ statements, but neither are working. Basically, what I am trying to do is find out if a worker from the main sheet is on another sheet showing as active, then I want to show the text active. If they aren’t on the sheet the I want to show “inactive”. I want this to be dragged down a full list of employees. I have tried the following =IF(A14='Employee List'!B14:B35,"Active","Not Active"). This works for the first cell but doesn’t work when the formula is dragged down. <o></o>
<o> </o>
I hope I have explained myself well. If not, I am happy to answer any further.<o></o>
<o> </o>
<o> </o>
Many thanks in advance.<o></o>
<o> </o>
<o> </o>
Kins.<o></o>

 

[SteveO59L]

Send me a pm with your e-mail, and I'll send you a worked example

 

[kins]

Send me a pm with your e-mail, and I'll send you a worked example

Ok, Steve. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
<o> </o>
PM Sent.<o></o>

 

[kins]

steve, it worked!! Thanks again.

 

[SteveO59L]

No worries.

Always a pleasure to assist the colonials

 

[kins]

No worries.

Always a pleasure to assist the colonials

Very Good.

Following on from the formula you gave me, can I just ask, what does the 'ISERROR' element of the formula mean/do? It's one things being able to achieve my task, but I would like to understand the formula going forward.


Thanks in advance.


Kins.

 

[SteveO59L]

If vlookup() doesnt find the target value, it will return #n/a - an error.

Iserror checks for errors (#n/a is just one type) - you could equally use IsNa, or Iserr.

 

[kins]

If vlookup() doesnt find the target value, it will return #n/a - an error.

Iserror checks for errors (#n

cheers, steve.