multiple column lookup

  1. L

    INDEX MATCH for unique value that could be in one of several columns

    I sure hope I can articulate this one, because it's been driving me batty (and had me searching every Excel site known to man) and I have a solution that FEELS overly complex. Maybe the big brains here at MrExcel can help me out! I have 5 columns of data with various options for a country name...
  2. M

    Returning value based on multiple column values

    Hope someone can help! I have a project register and I want to report on the phase each project is in... I have 4 stages, so based on the text in a specific cell I want to return specific text (or number) So here goes: If cell L4 = "Approved", return "1" But if cell U4 = "Approved", return...
  3. S

    Multiple Column Lookup

    I'm putting together a lookup tool. The columns are types of cars (trucks, SUV's, vans, cars), paint colors available on each car (green, red, blue, yellow), and the third column is the car name (F150, F350, Envoy, Astro Van, Grand Prix, Grand Am). The fourth column (which is the column...

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
Back
Top