Need vba to get first 2 value as result for Q_ID by vlookup from 2 sheet

HI experts

I have data which contains 3 sheet one raw data another 2 sub sheet

i want do if condition vlookup for get first 2 result from Jeop sheet and one result from Aerial sheet if find result sold ,rest of them unsold

look array values comes with slash

for e.g
if Q_id 0I86_NZD under FOI ID then refer first two values only from F column jeop sheetD= sold,sold
0I83_PHP
0I85_SGD

if Q_id 0I81_RUB under FOI ID then refer only one value from F column AERIAL sheet result in D=Sold
0I97_VND
0I76_LYD
0I77_ZAR

find the attachment.