Help with LookUp - I think!!

Diza

New Member
Joined
Sep 5, 2002
Messages
3
I have a summary sheet that has about 4500 rows on it .... basically it has employee number, cost centre, subjective columns followed by amounts by month. This is all OK. Now, however, I have to give these numbers text equivalents. That is I have to put a name matching to an employee number, and a location matching on BOTH the employee number AND cost centre.

So, I need two new columns. I have created a look up sheet within the same workbook that has names, locations and cost centres on it. It becomes a bit difficult because one employee number can have multiple cost centres and, hence, corresponding locations. BUT cost centres can have different locations.

Cost centres EB-ED correspond to particular locations but from EE onward they relate to a budget centre rather than a location and hence have multiple locations.

So, HELP!!! I'm not sure what formula to use - if any - have tried the IF function but that seems to require a value and doesnt want to return text.

Clear as mud .... thought so! Any help though would be outstanding.
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Jim North

MrExcel MVP
Joined
Jun 20, 2002
Messages
791
Hello Diza,

... and welcome to the board!

I think if you search for board for INDEX and MATCH you will find what you are looking for.

_________________
JRN

Excel 2000; Windows 2000
This message was edited by Jim North on 2002-09-06 04:33
 

Watch MrExcel Video

Forum statistics

Threads
1,129,682
Messages
5,637,763
Members
416,982
Latest member
lisam77

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top