How would i use the excel formula below in the vb code?
=IF(VLOOKUP(B3, G8:N17, MATCH(H7, G7:N7, 0), FALSE), H7 & "|", "") & IF(VLOOKUP(B3, G8:N17, MATCH(I7, G7:N7, 0), FALSE), I7 & "|", "") & IF(VLOOKUP(B3, G8:N17, MATCH(J7, G7:N7, 0), FALSE), J7 & "|", "") & IF(VLOOKUP(B3, G8:N17, MATCH(K7, G7:N7, 0), FALSE), K7 & "|", "") & IF(VLOOKUP(B3, G8:N17, MATCH(L7, G7:N7, 0), FALSE), L7 & "|", "") & IF(VLOOKUP(B3, G8:N17, MATCH(M7, G7:N7, 0), FALSE), M7 & "|", "") & IF(VLOOKUP(B3, G8:N17, MATCH(N7, G7:N7, 0), FALSE), N7 & " ", "")
=IF(VLOOKUP(B3, G8:N17, MATCH(H7, G7:N7, 0), FALSE), H7 & "|", "") & IF(VLOOKUP(B3, G8:N17, MATCH(I7, G7:N7, 0), FALSE), I7 & "|", "") & IF(VLOOKUP(B3, G8:N17, MATCH(J7, G7:N7, 0), FALSE), J7 & "|", "") & IF(VLOOKUP(B3, G8:N17, MATCH(K7, G7:N7, 0), FALSE), K7 & "|", "") & IF(VLOOKUP(B3, G8:N17, MATCH(L7, G7:N7, 0), FALSE), L7 & "|", "") & IF(VLOOKUP(B3, G8:N17, MATCH(M7, G7:N7, 0), FALSE), M7 & "|", "") & IF(VLOOKUP(B3, G8:N17, MATCH(N7, G7:N7, 0), FALSE), N7 & " ", "")