Go Back   Cyber Tech Help Support Forums > Software > Applications

Notices

Applications Use this board for problem solving and the discussion of computer software applications

Reply
 
Topic Tools
  #1  
Old April 1st, 2022, 04:02 PM
CyberTrek CyberTrek is offline
Senior Member
 
Join Date: Aug 2008
Location: NC, USA, Earth, Sector 001
Posts: 574
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.
Reply With Quote
  #2  
Old April 1st, 2022, 05:16 PM
CyberTrek CyberTrek is offline
Senior Member
 
Join Date: Aug 2008
Location: NC, USA, Earth, Sector 001
Posts: 574
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.
Reply With Quote
Reply

Bookmarks

Topic Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

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 03:12 PM.