concatenate:
=CONCATENATE("'",A2,"',")
vlookup:
=VLOOKUP(A3,$AA$2:$AA$40,1,FALSE)
Showing posts with label Excel Tutorial. Show all posts
Showing posts with label Excel Tutorial. Show all posts
Formula concatenate & vlookup in Excel
Subscribe to:
Posts (Atom)