Lookup a cell value from Multiple Columns

[rubz71]

Hi All,

Need help with a Formula for Column "Scheduled_UOM"

The formula should read from F2(UOM, Meters) and look into Columns B(Meters), C(Mass) ,D(Materials) ,E(Bends) and if it matches with the text, the formula should output the Value under "Shceduled_UOM" column.

Hope this is not too complex to do.

Thank You.

Customer	Metres	Mass	Materials	Bends	UOM	Schedule_UOM
ABC	3​	10​	1​	0​	Meters	3​
CDE	4​	12​	2​	0​	Mass	12​
EFG	5​	14​	3​	0​	Meters	5​
HIJ	6​	16​	4​	7​	Bends	7​
XYZ	7​	18​	5​	0​	Materials	5​

 

[ouvay]

Here you go

=INDEX(B2:E2,MATCH(F2,$B$1:$E$1,0))

 

[rubz71]

Thank you

 

[ouvay]

Thank you

No worries

 

[rubz71]

No worries

Can you please help with the below thread?

Dynamic Lookup Value using Column and Row

Hi All, Need a bit of help with a dynamic look-up value. Sheet 1 contains the Machine Name and Day of the week. Sheet 2 contains list of Machines and their capacity per day. I need to fill the "Capacity" column in sheet 1 based on the machine name and day of the week from Sheet 2...

www.mrexcel.com

 

[ouvay]

Can you please help with the below thread?

Dynamic Lookup Value using Column and Row

Hi All, Need a bit of help with a dynamic look-up value. Sheet 1 contains the Machine Name and Day of the week. Sheet 2 contains list of Machines and their capacity per day. I need to fill the "Capacity" column in sheet 1 based on the machine name and day of the week from Sheet 2...

www.mrexcel.com

yup, writing it now