v-look up

  1. M

    V look up help needed

    I have an excel spreadsheet having information in two sheets i.e. sheet 1 and sheet 2 Sheet 1 has 3 columns. Column A (Description) consists of repetitive values Column B (Job Title) Blank cells {Information needs to be populated from Sheet 2} Column C (University) Blank cells {Information needs...
  2. S

    V look up? Help

    Hi I have never really used V look up before and correct me if I'm wrong but I think v look up is what I will be needing to use to fulfil my request below: I have a document which lists staff members who have completed their training or started their training. Now in an excel document, the...
  3. P

    V-lookup help

    I have to reach out to this forum as I've hit a brick wall (brick wall being, simply not enough smarts!). I'm thinking V-look up or Match but not really sure how to achieve the desired result. In the layout below I want retrieve from sheet 1, the person for each address. Note: In the actual...
  4. I

    How do I return a columns values into a different sheet using a column name?

    Okay, so what I'm trying to do is something similar to a v-look up, except I want to search by a column name. For instance: I have Excel file 1 with only two column names, "Fruits" in A1 and, "Vegetables" in D1. So it looks like: <tbody> Fruits </tbody> Vegetables In Excel file 2 I have...
  5. C

    I need a look-up function within Excel that works on an inconsistent set of data

    Any idea's? Basically, I get fuel costs each month on a spreadsheet for each team within our company. It has the months scrolling across the top (B2:L1) and the team names going down (A1 onwards) with a total under each one team. The problem is, we get new people joining the company or leaving...

Watch MrExcel Video

This Week's Hot Topics

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