Thread: excel formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lbruce Lbruce is offline
external usenet poster
 
Posts: 1
Default excel formulas

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