Thread
:
Two column value match table look up
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Max
Posts: n/a
Two column value match table look up
"Biff" wrote:
Think the double Index is redundant:
=INDEX(DBTable,MATCH(1,(WorkOrderNunber=A1)*(JobNo =B1),0),C1)
Yes, of course. Thanks for the refinement !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With Quote