Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Enter this formula in H4 and drag across upto L4

=VLOOKUP($G4,$A:$F,COLUMN(B1),0)