Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello from Steved
Cell A1 =VLOOKUP(F6,$U$2:$Z$2000,2,0) will get the Surname ie "ADDISON" Cell B1=VLOOKUP(F6,$U$2:$Z$2000,3,0) will get the first Names ie "Mark James" Ok can I get the formula to combine the both to get = "ADDISON Mark James" so cell A1 ="ADDISON Mark James" or so cell A1 ="ADDISON Mark James" (Wrap Check box ticked) Thankyou. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum product help needed with an extra variable please and thankyou | Excel Worksheet Functions |