Nov 29 2022 11:34 PM
You can use vlookup to look for value.
What value you want to find in what column?
Nov 30 2022 01:00 AM
please refer the attachment.
Nov 30 2022 01:36 AM - edited Nov 30 2022 01:37 AM
Nov 30 2022 01:36 AM - edited Nov 30 2022 01:37 AM
So, you want cell O10 to get the value from the table according to the value in cell N10, this is the formula you should write in Cell O10
=VLOOKUP(N10,J5:L46,2,FALSE)
See the file attached