|
VLOOKUP
I am in cell D908.
This is my formula: =IF(E908=" "," ",IF(A908<0,"D"&MID(A908,2,255),VLOOKUP(C908,AllC odes!$A$11:$E$824,1))) Gives me: X72000 All numbers from column 1 on the AllCodes worksheet begin with X. I would like it to return: D72000 Is it possible to accomplish this in cell D908 or Do I have to create another column for the conversion? |
VLOOKUP
So, in your result, presumably A908 = 0
So, "D"&right(VLOOKUP(C908,AllCodes!$A$11:$E$824,1),le n(VLOOKUP(C908,AllCodes!$A$11:$E$824,1))-1) will repalce with a D at the beginning... "evoxfan" wrote: I am in cell D908. This is my formula: =IF(E908=" "," ",IF(A908<0,"D"&MID(A908,2,255),VLOOKUP(C908,AllC odes!$A$11:$E$824,1))) Gives me: X72000 All numbers from column 1 on the AllCodes worksheet begin with X. I would like it to return: D72000 Is it possible to accomplish this in cell D908 or Do I have to create another column for the conversion? |
| All times are GMT +1. The time now is 02:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com