View Single Post
  #1   Report Post  
Dmorri254
 
Posts: n/a
Default Formula Modification Help

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,FALSE))