I need some assistant in writing a formula that will match to columns"B" &"E"
and give me the data from another column "F". (this data coming from two
different databases and they are not linked in a dos system we use)

if "b"&"e"(match or equals)put oper name in "D"

A B C D
E F
DATE DEPART# COST OF ISSUE OPER NUM
OPER NAME
05/11/08 000025 -10.59 000000
adj to invtry
05/05/08 000000 2.50 000000
adj to invtry
05/09/08 000001 50.99 000025
cut-up s/o

Indicatively, try something like this in C2, array-entered (press
CTRLS+SHIFT+ENTER to confirm the formula):
=index(x!F2:F100,match(1,(x!B2:B100=A2)*(x!E2:E100 =B2),0))
where A2, B2 contains the lookup values corresponding to cols B and E in
sheet: x, and x's col F is the desired return col.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lbruce" wrote:
I need some assistant in writing a formula that will match to columns"B" &"E"
and give me the data from another column "F". (this data coming from two
different databases and they are not linked in a dos system we use)

if "b"&"e"(match or equals)put oper name in "D"

A B C D
E F
DATE DEPART# COST OF ISSUE OPER NUM
OPER NAME
05/11/08 000025 -10.59 000000
adj to invtry
05/05/08 000000 2.50 000000
adj to invtry
05/09/08 000001 50.99 000025
cut-up s/o