Perhaps


=IF(ISNA(MATCH(--MID(H3779,1+2*(LEFT(H3779)="IM"),255),PSWRDREQ,0)) ,"",
VLOOKUP(--MID(H3779,1+2*(LEFT(H3779,2)="IM"),255),PSWRDREQ,2 ,FALSE))

This assumes that H3779 may or may not be prefixed with IM, and that
your lookup range is numeric. 255 is just a big number

In article ,
Dmorri254 wrote:

Hmm...this approach did not work....lets see if I can be more clear....I need
it to say If the number is IM whatever, ignore the IM and just give me the
numbers...

Does this help? Thank you so much...