This video shows the use of vlookup with indirect Fx

https://youtu.be/0kYzmBncec4