Do you mean?
=IF(ISERROR(VLOOKUP(H3779,PSWRDREQ,2,FALSE)),"",IF (LEFT(VLOOKUP(H3779,PSWRDR
EQ,2,FALSE),2)="IM",MID(VLOOKUP(H3779,PSWRDREQ,2,F ALSE),3,32),""))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Dmorri254" wrote in message
...
Hello,
I need to modify the lookup formula below because what it now looks for
has
the letters IM in front of the munbers. Example IM1780 where before they
were
straight numbers. Example 4160048
I would like to say If (H3779,PSWRDREQ,2) is equal to IM....then only
give
me the numbers to the right of the IM. Example 1780....
Can you plese help? The formula as it is now is:
=IF(ISERROR(VLOOKUP(H3779,PSWRDREQ,2,FALSE)),"",VL OOKUP(H3779,PSWRDREQ,2,FAL
SE))
|