|
Applications Use this board for problem solving and the discussion of computer software applications |
|
Topic Tools |
#1
|
|||
|
|||
Excel vlookup Assistance
Hello. I am having a bit of an issue trying to make a VLOOKUP formula.
I have in column A these entries: sysD123 sysG123 sysH123 I am trying to make a formula in column B that will see the 4th character (in this example, I capitalized them) and name them based on the criteria that D=delta, G=gamma, H=hoyboy. So, B would have these: Delta Gamma Hoyboy But, I can not get it to see the character correctly, only the cell. Any help be appreciated. Thank you. |
#2
|
|||
|
|||
Got it figured out.
So, you got system names in A. sysD123 sysG123 sysH123 In another tab, called Lookup in this case: -D delta -H gamma -G hoyboy Formula in main tab column B: =VLOOKUP(MID($A2,3,2),Lookup!$A:$B,2,0) MID($A2,3,2) Taking the value in A2, starting with the third character, take the two characters after. WX-D1000 3rd character is starting point, the dash. Two characters are -D. In the tab Lookup, using !, look in A and B, matching the two characters from MID, and matching with the results in B. |
Bookmarks |
«
Previous Topic
|
Next Topic
»
|
|
Similar Topics | ||||
Topic | Topic Starter | Forum | Replies | Last Post |
Assistance please | The Dude | Windows 98 | 2 | October 29th, 2011 12:11 AM |
Need some assistance | PostCode | Linux | 4 | November 12th, 2007 05:30 PM |
Need assistance with HJT log | Pado | Malware Removal | 3 | February 16th, 2007 01:38 PM |
HT Assistance? | Legin | Malware Removal | 5 | July 6th, 2004 03:07 AM |
Excel 2000 - Excel XP | JustJay | Applications | 0 | March 11th, 2002 06:19 PM |
All times are GMT +1. The time now is 06:51 AM.