Multiple lookups on specific results

[Althas]

HI all, I hope this makes sense

What I essentially need to do is this:
On “Forecast” tab (Col Q) look up the Clino (Col D) against every instance of that Clino on the “Info” tab (Col A). When it matches the Clino, it then does a lookup of the Service Code ("Info" tab Col J) against the table on “Lookups” tab. If it finds it then it returns the value in "Lookups" Col B

So “Forecast” Q2 would read Allowance for removal of personal possessions
And “Forecast” Q3 would read Leave

The “Forecast” and “Info” would both be variable length

Thanks

[FDibbins]

Maybe Im missing something here, but how do you decide which of the 6 entries in Ifo to use, to get "Allowance for removal of personal possessions"?

[Althas]

Maybe Im missing something here, but how do you decide which of the 6 entries in Ifo to use, to get "Allowance for removal of personal possessions"?

The Service Code ("Info" tab, Col J)

[FDibbins]

That doesnt tell me how I find that, based on the Clino number from Forecast?

[Althas]

Sorry if I have not explained it clearly

The Clino from Forecast is checked against each Clino on Info. When they match the Service Code on that line is then checked against the table on Lookups. If that matches then the text in Lookups Col B is returned

I hope that makes better sense for you
Thanks