0

I need to fill in a cell with a value (account number) based on 2 different values (account name and department name) in 2 columns.

I have a table with account name in column A, Department number in column B and the lookup value which is Account number in column C because I have duplicate account name such as salaries in different departments and I want to differ between these accounts by account number.

Improve this question
3
  • Welcome! Is it "account number" is real number, not a text string? Well, what about SUMIFS() or MAXIFS() function?
    – JohnSUN
    Commented Jun 8, 2023 at 9:46
  • Or FILTER the values based on the two criteria: =FILTER(C:C, (A:A=x)*(B:B=y))
    – Blindspots
    Commented Jun 8, 2023 at 12:57
  • This works for me: =XLOOKUP(AccName & DeptName, Acc_Column & Dept_Column, AccNum_Column) - e.g. =XLOOKUP(F3 & G3,$A$3:$A$10 & $B$3:$B$10,$C$3:$C$10)
    – Darren Bartrup-Cook
    Commented Jun 9, 2023 at 7:02

0

Reset to default

You must log in to answer this question.

Browse other questions tagged .