Looking up status across different sheets

**Warmigu** · 07-25-2019, 02:17 AM

Hi everyone

I'm new here! I work for a small NGO which provides humanitarian assistance to people in conflict. We have a very small budget and IT support is quite limited so I am often left to work things out on my own. So, please excuse how novice this question is

We receive a lot of referrals from partners in order to provide assistance. I am trying to find a way using OneDrive to allow partners to enter a reference number and check the status of a referral without having to always email me about it.

Right now there are two lists of referrals (currently in two different excel files but I want to put them as two sheets in one file). I want to create a separate excel sheet where you can enter the reference number and see the status of the referral and who it has been assigned to. The reason I want this to be on a separate excel sheet is that I do not want confidential or internal information visible to partners.

Can you guys help me out? Please let me know what else you would need from me so we can work it out together.

**AliGW** · 07-25-2019, 02:22 AM

Welcome to the forum.

Sounds like you need something simple like a VLOOKUP or INDEX MATCH, but it would be easier to see the context.

Will you please attach a small sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.