أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
HOW CAN WE APPLY TWO VLOOKUP ON SINGLE CELL
if I get your question correctly
you can use:
sd
100 120 f 400123 f 400 123 sd 100120
I used below formula in a single cell to get the results in E1, if you consider "sd" is in Cell A1 and accordingly.
=VLOOKUP(D1,A:B,2,0)&VLOOKUP(D:D,A:C,3,0)