Ask Your Question

Revision history [back]

It can be done using VLOOKUP but you have to reformat your F column. In F column, keep only one item per row.

Then, in C3: =VLOOKUP(A3,F:H,2,0) D3: =VLOOKUP(A3,F:H,3,0)

Drag the handle till your data exists.

image description