Lookup and More?

roy1987 · #1 08-18-2008, 03:47 PM

Hi,

I am, as one would call, a noob. Not just on this forum. but also on Excel. And its only recently that i've decided to try to replace the more clerical aspects of my job with the complicated excel formulaes (complicated for me atleast)..

Here's a example (somewhat simpler version of the task i'm attepmting to handle smartly)

What i'm trying to achive might appear rather rudimentary to some (a part of it is rather simple)

So here's what I'm trying to do:

1. This is the Original Data. 4 columns: Level, Name, Function, Code

2. Reference Table for 'Name'

3. Reference Table for 'Code'

4. The Final Result.

Firstly the easy part.. I vlookup the Function from 2

Now is that part thats taking up too much of my time doing manually. I lookup the codes corresponding the Function, followed by a '0' and finally followed by the corresponding 'Level'
like in at first case DU01

Its is possible rgt?

Thanks..

PS: I did try posting this in the 'General Excel' Forum, but it just would not allow me to link pictures??

**NBVC** · #2 08-18-2008, 03:51 PM

Probably

=Vlookup(C5,Codes!$A$5:$B$8,2,0)&0&A5

where Codes!A5:B8 contain your codes

roy1987 · #3 08-18-2008, 03:58 PM

Thanks!!!
Worked perfectly

Would it still work if the Start Data was a bit different. Say:

Here I would have to pick just the '1' from 'H1' and come up with DU01 again?

thanks a lot!

**NBVC** · #4 08-18-2008, 04:06 PM

Something like:

=Vlookup(C5,Codes!$A$5:$B$8,2,0)&0&MID($A5,2,10)

roy1987 · #5 08-18-2008, 04:16 PM

Quote:

Originally Posted by NBVC

=Vlookup(C5,Codes!$A$5:$B$8,2,0)&0&MID($A5,2,10)

Thanks a Lot!!

Can't wait to try this in office tom!!

cheers

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)