View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nightrain Nightrain is offline
external usenet poster
 
Posts: 3
Default Looking up multiple values and returning one corresponding value

I am wondering if it is possible to lookup multiple values using the vlookup
function and return one corresponding value? More specifically, I want to
lookup a part number and machine number and then return a value associated
with each of the two criteria. I have tried using nested vlookup functions,
but have yet to get anything to work properly. Any ideas? Thanks in advance.