=A1&" "&B1 can be used to display 2 cells together in a other cell with a space between them
Can it be used with VLOOKUP
Value A1 = 1
Value B1 = ONE
Value C1 = TWO
Value D1 = THREE
I am using this formula in J1
=IF(I1="","",VLOOKUP(I1,A:D,2,FALSE))
So If I put 1 in I1, "ONE" will show in J1
Can B1, C1 & D1 be displayed togeteher in J1 (ONE TWO THREE)
Bookmarks