Hi I have a table of data contaning
department name op number production


AA1 AA2 AA3
press op 10 40
wash op 10 90

A5 = press
b5 = op 10

i want to return the value of the identified op in b5 from the
identified department in a5
i am trying to use vlookup to achieve this


any suggestion on the best way forward


thanks


kevin