vlookup

R

RichardO

Hello all:

I hope you can help with the following:

I have to lookup a number in worksheet A within a range, "Range", i
the number is not available in the range, I want a "" in my cell. I
the number is available it should lookup the 18th cell. In the 18t
cell, I could have a date in there OR a words such as confirmed, route
e.t.c. If it is a date, it should provide me the date in my cell, i
it is anything other than confirmed, it should put a blank, if it i
confirmed, it should take cell m2+3 workdays. I have the followin
formula but I all blanks, something is not right, pease help.

=IF(ISNA(VLOOKUP(N2,Range,18,0)),"",IF(VLOOKUP(N2,Range,18,0)<>"confirmed","",IF(VLOOKUP(N2,Ragne,18,0)="MAIL",M2+3,VLOOKUP(N2,Range,18,0))))

Richardi
 
D

Don Guillett

Without going any further, you might take a look at the spelling of range vs
ragne
 
P

Peo Sjoblom

One way

=IF(ISERROR(MATCH(N2,INDEX(Range,,1),0)),"",IF(VLOOKUP(N2,Range,18,0)="confi
rmed",WORKDAY(M2,3),IF(ISNUMBER(VLOOKUP(N2,Range,18,0)),VLOOKUP(N2,Range,18,
0),"")))

--

Regards,

Peo Sjoblom
 
R

RichardO

Hello:

Thanks for the post Peo, the formula worked, I also changed the matc
to vlookup (because I don't really understand how match and index work
and it seems to be fine.

This is for anyone that can help. I have been battling with this fo
an hour or so and I don't see what's wrong with the formula:

=IF(ISblank(NETWORKDAYS(H2,R2)),NETWORKDAYS(H2,S2),IF(ISblank(NETWORKDAYS(H2,R2)),"",NETWORKDAYS(H2,R2)))

In my cell, I want excel to give me the working days between dates in
and R, but if R is blank, it should give me the days between H and S
if S is blank, I want it to give me a blank instead.

It's not giving me the blank that I want when column R or S is blank.
Column R and S have a vlookup formula in them that makes them blank o
have a date depending on if the vlookup can find anything.


Thanks


Richard
 
Top