談天說地主旨 ﹝請按主旨作出回應﹞ | 寄件者 | 傳送日期 |
[#1] Excel Question Hope someone can help, thank you. Table: 8893-2 $12 8893BK $10 8893WT $10 8893GG $10 I want to know the price: 8893 (WORD) is a group and 8893-2 is another group. if I vlookup 8893* it will return $12 How can I make it return $10 So I want to find 8893* but without a "-" 最後修改時間: 2023-03-23 12:26:40 |
vinsee_new 正式會員 42.xxx.xxx.38 |
2023-03-23 12:25 | |
|
[#2] Excel Question #1 Creat another column( with formula and no need to type e.g. Left(A2,5) etc) which can separate the similar wordings. Then Vlookup the first and 2nd column together. |
ich 正式會員 112.xxx.xxx.21 |
2023-03-23 12:35 |
[#3] Excel Question Thank you sin. I will try try again. |
vinsee_new 正式會員 42.xxx.xxx.38 |
2023-03-23 15:18 |
[#4] Excel Question #3 Key point 係你有冇辦法去分出唔同groups ?唔同groups係唔同D乜? 之後either用columns 或formulas 去分開呢D特徵.其實有可能一條formula 包括VLOOKUP去做到 |
ich 正式會員 112.xxx.xxx.21 |
2023-03-23 15:49 |
[#5] Excel Question 問咗chatGPT未 :) |
yy256 正式會員 182.xxx.xxx.105 |
2023-03-23 16:07 |
[#6] Excel Question 最後修改時間: 2023-03-23 17:17:55 |
bambino 正式會員 210.xxx.xxx.231 |
2023-03-23 17:15 |
按照傳送日期顯示:由舊至新 由新至舊 |