Hi Allan,
I'm getting an error mesage
VLookups("paid",A1:B3,2) - (User-defined function)
paid vendor # 1
paid Vendor # 2
#VALUE
Can you help me?
"Alan Beban" wrote:
You might want to consider making the functions in the freely
downloadable file at http://home.pacbell.net/beban available to your
workbook. Then you could array enter into a multi-celled column
=VLookups("paid",a1:c3,2)
Alan Beban
Jeff wrote:
Hello,
I need to do a vlookup in a VBA Macro for the values in column "B." However
the values in the Table Array of column "A" are the same. Can I combine a
Vlookup and an Offset ?
Ex:
Column A Column B
Paid Vendor 1
paid Vendor 2
Etc