Google Sheets Formula

[gimamabe71]

I would like to import the account number into cell B2 when a selection is made for an expense category in cell A2 from a dropdown menu.

Expense Category	Account
Contracts - General

The dropdown menu in cell A2, uses data validation from a table in a separate tab "selection lists". The data validation range for the dropdown menu in Column B.
The account number to be imported is in Column C

Expense Categories
Contracts - General	25555
Food Catering	32222
Miscellaneous	43333

I am using google sheets, What formula should I use? I am using IF but is not working.

Any advice will be highly appreciated

 

[etaf]

try
=index('Selection lists'!C2:C10000,match(A2,'Selection lists'!B2:B10000,0))

A lookup that looks up the value from the dropdown and then looks in the dropdown list sheet and returns the value in same row in column c

Change the range to match your list in 'Selection lists' sheet