function

[Guido Cole]

On worksheet 1 I have a list of suppliers in the first column.
On worksheet 2 I have 2 columns: name of supplier and payment conditions.
Which function should I use on column 2 of worksheet 1, to auto fill the
payment conditions for the corresponding supplier?
I have tried Match and Lookup but they gave incorrect results in some cases.

 

[CyberTaz]

One option would be to use the VLOOKUP fx. If the data on sheet 2 is in
cells A1:B10, for example, & your list of suppliers on sheet 1 starts in
cell D12, put the following in cell E12 of sheet 1 & copy down as far as
necessary:

=VLOOKUP(D12,sheet2!$A$1:$B$10,2,false)

Just make sure that the reference to the table of suppliers *does not*
include the caption row - IOW, in the example above, if on sheet 2 A1 & B1
actually contain captions such as "Supplier" & "Conditions" the reference in
the formula should actually read as $A$2:$B$10 - just the cells that
actually contain supplier record data.

HTH |:>)
Bob Jones
[MVP] Office:Mac