View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] the_cagey_one@excite.com is offline
external usenet poster
 
Posts: 6
Default VLookup based on two criteria

I've read through many posts on this topic but I've not been able to
find a solution to my problem.

On one tab I have six columns of information (table_array.) Column
"A" contains a machine name, Column "B" contains a fault name and
column "F" contains a time value (decimal minutes.) For each machine
there may be any number of faults associated to it. I am trying to
return the time value for a specific machine's fault name to a
corresponding cell on another tab in the same worksheet.

The lookup_value will come from another reference in the document; I
can work through that but cannot resolve the two criteria requirement
(machine and fault name) to pull in the time value.

Any response is appreciated.

KG