Finding Best Match

[Manny Singh]

Hello Excel Masters,

I have got a query which is a bit challenging, hoping it can be solved with excel.

Attached sheet shows value for Material column and there are three lookup columns, can a formula be created to find the best match for Material column.

Answer should be Lookup 2 highlighted in yellow, I would be delighted and amazed at the same time if a formula can be created to find the best match.

Regards,
Manny

 

[xlstime]

Hi Manny,

Best match on what bases?

Hello Excel Masters,

I have got a query which is a bit challenging, hoping it can be solved with excel.

Attached sheet shows value for Material column and there are three lookup columns, can a formula be created to find the best match for Material column.

Answer should be Lookup 2 highlighted in yellow, I would be delighted and amazed at the same time if a formula can be created to find the best match.

Regards,
Manny

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[Manny Singh]

Hi Manny,

Best match on what bases?

Hi xlstime,

In the sheet, I have got four columns, one for material and three lookup columns.

I require a formula to find the best match for Material column out of three lookup columns.

Is it possible through excel?

 

[Manny Singh]

Hi Manny,

Best match on what bases?

Hi

Hi ,

See the attached file.

Narayan

Hi Narayan,

This is very clever, thanks you for taking time, though I will have to spend few minutes understanding the whole formula. You should sleep well tonight with the thought that you helped someone.

 

[bines53]

Hi Manny,

I was ready to give another solution, but I understand it is difficult for you to understand my solutions yet.

David

 

[Manny Singh]

Hi Manny,

I was ready to give another solution, but I understand it is difficult for you to understand my solutions yet.

David

Haha David, that's true mate, I am a bit slow learner in excel but I give it a go. I would love to see what other ways you can solve this.

 

[bines53]

I think, if it's worth taking the risk