VLOOKUP won't calculate....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please hel
The following VLOOKUP formula won't calculate? I've done something wrong obviously

=VLOOKUP($C19&$B19,deadlines,4

C19 = Nex
B19 = 1/4/04 (which equates to Next38078
deadlines = defined area on a separate worksheet covering A2:M33 and the columns have this data in it

Column 1 Col2 Col 3 Col 4 Col 5 Col

Name Open Start Close Alternat
Next38018 Next 1/2/04 22/1/04 15/1/04 13/1/0
Next38047 Next 1/3/04 22/1/04 15/2/04 13/2/0
Next38078 Next 1/4/04 22/2/04 15/3/04 13/3/0

Who38018 Who 1/2/04 1/1/04 15/1/04 13/1/0
Who38047 Who 1/3/04 1/2/04 15/2/04 13/2/0
Who38078 Who 1/4/04 1/3/04 15/3/04 13/3/0

the result should be 22/2/04???? but I'm getting 0/1/0

Secondly, I'm trying to nest the VLOOKUP into an IF formula - is this possible? ie

=if(VLOOKUP($C19&$B19,deadlines,4)>0,VLOOKUP($C19&$B19,deadlines,4),VLOOKUP($C19&$B19,deadlines,6)

Any help would be greatly appreciated.
 
Hi
for your first question try the following:
=VLOOKUP($C19&$B19,deadlines,4,0)

For the second one try
=IF(ISNA(VLOOKUP($C19&$B19,deadlines,4,0)),VLOOKUP($C19&$B19,deadlines,
6,0),VLOOKUP($C19&$B19,deadlines,4,0))


--
Regards
Frank Kabel
Frankfurt, Germany
BeSmart said:
Please help
The following VLOOKUP formula won't calculate? I've done something wrong obviously?

=VLOOKUP($C19&$B19,deadlines,4)

C19 = Next
B19 = 1/4/04 (which equates to Next38078)
deadlines = defined area on a separate worksheet covering A2:M33 and
Click to expand...
the columns have this data in it:
 
Back
Top