| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP and LEFT to match text?
Hey, kids! I'm back, with yet another attempt at frustration using Excel! Oh, boy, what fun!!!! In case you missed the last episode, I am trying to match names in 2 columns of text (that don't really match except for last name). You would think this is a realtively easy task, but I've been trying this off and on (mostly on) since 11 AM... Here's my newest failu =VLOOKUP(LEFT(H4,4),LEFT(B$4:B$32,4),1,FALSE) Result is not the first 4 characters of the last name as I hoped, instead I get a #VALUE message. Note: H as LN only, b4:b32 has a text formatted LN,FN Middle Initial. Can anyone tell me what I'm doing wrong? I can't figure this out at all. pleease, please please help... Mark Boston, MA -- LTUser54 ------------------------------------------------------------------------ LTUser54's Profile: http://www.excelforum.com/member.php...o&userid=33459 View this thread: http://www.excelforum.com/showthread...hreadid=544442 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text limit using a vlookup | Excel Discussion (Misc queries) | |||
| vlookup returns column to the left | Excel Worksheet Functions | |||
| HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
| Can Vlookup check a cell to the left? | Excel Worksheet Functions | |||
| VLookup ... Left side? | Excel Worksheet Functions | |||
Threaded Mode
