K
kevcar40
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
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