EXCEL - Find a value in a table/range and return a corresponding value/text

Question

I have a table/range of data (numbers and text) and would like to have excel evaluate the table to search for a value and return a corresponding "label" at the top of the table.

Any thoughts, help ??

Thank you,

Vance

Answer 1

Thank you for submitting help, tried both VLOOKUP & XLOOKUP but dont believe either would work in my scenario (note the example of what I'm trying to do, posted this morning).

thank you

Answer 2

Here's a screenshot of what I'm trying to get Excel to do/find.

Based on the Weight & Distance criteria (in yellow), find the corresponding value in the table and report back the "minimum" size of crane needed to safely lift the load.

Sorry this chart does not make sense.

Why do you have multiple entries for the same distance / weight?

Why could it not be reduced to:

Answer 3

Are the values entered going to be exact matches or any value less than or equal too?

Do you want to ensure minimize crane size, since 30 ton can handle all weight / distances combos a 17 ton one can?

Answer 4

Sorry about the confusion. I want to have a separate worksheet where the user simply enters the criteria and let Excel go find the corresponding "answer" from a separate worksheet (will be hidden). I was just putting all data/info & search criteria on one screenshot for ease of viewing here.

The "multiple values" you may be noticing are just simply the data for different "stages" or "lengths" of Crane Boom sections (as found directly on the Manufacturers data sheets). I've taken the data directly from the manufacturer.

Answer 5

Not looking for exact match's, but looking for a minimum value that satisfies the search criteria.

Yes, only looking to find/ensure minimum crane size is found.

thank you