IF column A = X and column B = Y then copy cell

Hi all,

Looking for some help on an IF copy and paste query please. I've got columns of data that I need to look up, if both criteria are met I would like to copy a cell to another cell.

There are 3 columns;

A - Location (London, Birmingham, Brighton)
B - Status (Available, Issued)
C - Serial Number (multiple variants)

The formula I need is to pull a list of available serial numbers at a certain location. So something like; if column A is Brighton and column B is available, then copy the serial number from column C.

I think I've attached a sample sheet to this post!

Any help would be appreciated, no much brain space left trying to work it out!

Many thanks,

Barry

Apologies! The result based on Brighton > Available would be;

Brighton
1235
1787754

I would then do the same formula for the other locations, but results entered in another cell/sheet.

Attached updated book.

Thank you. To give you more detail, this is being created as very basic asset checking system. If something is available at a location, I want it in a list.

Excel really isn't the tool for the job, but it's needed quickly so will I need to make it work!

I'll check out the add-in, thank you. Any help on a formula of some kind would be good though!

Thanks for you help.

Not quite sure I follow, but Brighton would always be in column A - but the list would grow so it would need to be A:A I think?