Results 1 to 3 of 3

Thread: vlookup help

  1. #1

    vlookup help

    Register for a FREE account, and/
    or Log in to avoid these ads!

    hi all so i have a sheet
    its called roster
    say one cell contains all the data below


    I know how to select certain part (left,right,mid) but want to include this with a vlookup
    how do i correct this ?

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Mississauga, Canada
    Excel Version
    Excel 2016
    =VLOOKUP(LEFT(C5,4),'Other Sheet'!A:B,2,FALSE)

    where Other Sheet is the name of the sheet you are looking for 1106 in, and it assumes you are looking in column A and extracting result from column B.

    If you are getting #N/A and you know there should be a match, then try:

    =VLOOKUP(--LEFT(C5,4),'Other Sheet'!A:B,2,FALSE)

    this coercest the 1106 it extracted to a real number that might be the way your data in the other sheet is formatted.

  3. #3

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts