Vlookup LEFT of the "^" sign, IF "^" is present in the string

Hi,
How can I write the Vlookup formula to look for data on Column B, that identifies all data that does not have the "^" present, and only data left of the "^", IF "^" is present?

I am trying to run the lookup function on a field that may have the "^" sign in the "middle" of the B Column data. The "^" may not be present, but if it is, it can be positioned on the 6th, 7th, 8th, or 9th place. If it is present I need to lookup only the data to the LEFT of it.
If/when I use the Left formula imbedded in the vlookup it works. However I have to manually adjust the formula according to the place of the "^" sign. When the list/table is very long that this solution is not practical.

This works =VLOOKUP((LEFT($B4,8)),[Source_Data_Sample.xlsx]Source_Data_Sample!$A$2:$V$24,5,0)

Here is a sample of the data on my table 1 :

4968.OS
4968.T
4968.KAB^K11
ACM.L^I08
ACM.PO^I08

and this is the data on "Surce_Data...table:
4968.OS
4968.T
4968.KAB
ACM.L
ACM.PO

Thank you,
Constantin

...no words, just a big smile; you're the man.
Thank you

Shorter and elegant version:

=LEFT(A1,FIND("^",A1&"^")-1)

nicely done; thank you

You're Welcome!