Hello!
Been trying to get my head around this and googling some solutions, but without any luck based on my requirements.
I need to a lookup based on if a cell contains some text. It then needs to lookup a code on another sheet a find a match to the text, and then get an ID. I've got an example template but unsure if I can post on here.
This is my current workings but the issue I have is I have multiple rows with the same Code that I use in the Lookup -
=IF(SEARCH("VEP - ",D3),VLOOKUP(C3,'Lkup Central Budget'!A:E,2,TRUE), " ")
I've added some images if that helps, I may not be explaining clearly enough! A lookup may not be the best thing obviously, but just going off my current knowledge!
Any help will be appreciated!
Been trying to get my head around this and googling some solutions, but without any luck based on my requirements.
I need to a lookup based on if a cell contains some text. It then needs to lookup a code on another sheet a find a match to the text, and then get an ID. I've got an example template but unsure if I can post on here.
This is my current workings but the issue I have is I have multiple rows with the same Code that I use in the Lookup -
=IF(SEARCH("VEP - ",D3),VLOOKUP(C3,'Lkup Central Budget'!A:E,2,TRUE), " ")
I've added some images if that helps, I may not be explaining clearly enough! A lookup may not be the best thing obviously, but just going off my current knowledge!
Any help will be appreciated!