Thread: Look up 2 values, return result in a different workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Positive Positive is offline
external usenet poster
  
Posts: 37
Default Look up 2 values, return result in a different workbook
I need to look up name and then id then return the salary to a
different workbook.
e.g
Jack 0 $35,000
Allen 2 $45,000
Jack 3 $46,000
Mike 4 $72,000

I want to look up Jack who has id #3 and put his salary to a DIFFERENT
WORKBOOK.

Please help

Reply With QuoteReply With Quote