Multiple IF''''s with Vlookup wrote...
I think i am very close now.

Could you please let me know how to use Multiple IF's in the same example
....

No.

My response was specifically to Pete_UK. His formula didn't do what he
claimed it did.

I have no idea what you're trying to do because you haven't yet managed
to provide a cogent explanation. Until you do so, you're on your own.