Return a value based on a substring from a cell in Google Sheets

[Michelleaneous]

How to return the "Ship From" in Cell B2 based from the data in another tab with a substring criteria in Col A (currently listed in Col E/F)

 

[etaf]

had a play on google sheets - index/match with a right should work
=index(Sheet2!B:B,match(right(A2,3),Sheet2!A:A,0))
however as the supplier maybe any length of character

=index(Sheet2!B:B,match(right(A2,len(A2)- search("-",A2)),Sheet2!A:A,0))
not sure if this links to google sheets

Index

Sheet1 1234-abc,county-abc,abc 4567-def,town-def

docs.google.com

heres is the excel version

Untitled spreadsheet.xlsx
	A	B	C	D
1
2	1234-abc	county-abc		abc
3	4567-def	town-def
Sheet1

Cell Formulas
Range	Formula
D2	D2	=RIGHT(A2,LEN(A2)- SEARCH("-",A2))
B2:B3	B2	=INDEX(Sheet2!B:B,MATCH(RIGHT(A2,LEN(A2)- SEARCH("-",A2)),Sheet2!A:A,0))
Press CTRL+SHIFT+ENTER to enter array formulas.

Untitled spreadsheet.xlsx
	A	B
1	abc	county-abc
2	def	town-def
Sheet2

 

[etaf]

ok, so i thought i had shared public
i have answered your share request and also
made public

Index

Sheet1 1234-abc,county-abc,abc 4567-def,town-def

docs.google.com

see if that works now

not used google sheets for years - sorry