Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

excel用vlookup 要配合mid時,要如何連結?

我想用excel 取出張三的生日的中間月份時,例如:33.04.19 要如何作?

我是用 vlookup 以他的編號如0034,找到他的姓名,地址,電話

那用同樣的方法,也找到了他的生日,

這個時候,我只要取出月份的「04」時,

這兩個函數要如何連在一起,才會出現「04」?

謝謝!

2 Answers

Rating
  • 老夥
    Lv 7
    9 years ago
    Favorite Answer

    假設生日在E(第5欄)

    =MID(VLOOKUP(編號欄,資料範圍,5,),4,2)

    例如:=MID(VLOOKUP($A1,資料!$A$1:$E$10,5,),4,2)

    2012-07-06 20:05:18 補充:

    冰大客氣囉!

    假設生日在E(第5欄)

    =MID(VLOOKUP(編號欄,資料範圍,5,),4,2)

    例如:=MID(VLOOKUP($A1,資料!$A$1:$E$10,5,),4,2)

  • cjw
    Lv 5
    9 years ago

    設生日欄為D2則e2公式為

    Vlookup(mid(d2,4,2),查詢表範圍,間隔數,0)

    試試看

Still have questions? Get your answers by asking now.