Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am in the process of designing a spreadsheet and have came to a stumbling
block! I need excel to look at a cell and if the 4th digit is equal to A,B,C, D, etc insert the corresponding number i.e. if excel looks at cell 'A1' the number in that cell is 123B123 then in cell 'B1' I want it to enter 12345, if it was 123C123 I would want it to insert 56789, if D 13465 would appreciate any help. I have on the worksheet the list of letters and the list of corresponding numbers so was wondering about some sort of lookup? yours Aye Bruce |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Use VLOOKUP:
in B1: =VLOOKUP(MID(A1,4,1),D1:E3,2,FALSE) Columns D-E contains your lookup table as shown below A B D E 123B345 56789 A 12345 B 56789 C 13645 HTH "PIPERHAMMY" wrote: I am in the process of designing a spreadsheet and have came to a stumbling block! I need excel to look at a cell and if the 4th digit is equal to A,B,C, D, etc insert the corresponding number i.e. if excel looks at cell 'A1' the number in that cell is 123B123 then in cell 'B1' I want it to enter 12345, if it was 123C123 I would want it to insert 56789, if D 13465 would appreciate any help. I have on the worksheet the list of letters and the list of corresponding numbers so was wondering about some sort of lookup? yours Aye Bruce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I insert a line feed in the text in an EXCEL cell? | Excel Discussion (Misc queries) | |||
how to insert page numbering in an excel cell | Excel Discussion (Misc queries) | |||
How to insert a barcode into an Excel sheet cell? | Excel Worksheet Functions | |||
have a calendar pop up in a cell to pick & insert a date in excel | Excel Worksheet Functions | |||
Insert a standard character in a cell of excel. | Excel Worksheet Functions |