Return value based on multiple criteria in Excel

Hello,

Please look at my attached file - you will notice two sheets, "Serial_Number" and "Item List.

Serial_Number
This sheet contains items on rows and account IDs on columns.
Each item could potentially have 1 serial_number per account. I would like to display the serial numbers from the sheet "Item List" in the appropriate field in this sheet.

Item List
This sheet contains every single combination of item / account and includes the serial number.

Can anyone help me with a formula to move the appropriate serial numbers into the first sheet?

I have tried Vlookup but i can only base the results on one piece of criteria.

I would really appreciate some help here

Hi,

Thanks for that!
It works great for column C, but when i copy to the right i can't do the same for every account number.
Any ideas?

Many thanks in advance!

Thanks Again,

Unfortunately this isn't really what i'm after.
If you like at the sheet "Item List" and search for all rows with an "account_ID" of "1000091" you will find just 1 row.
This would mean that the sheet "Serial_number" will only have 1 serial_number (FMD0072056) in column C row 35.

I hope this helps!

Haha well you are doing a better job than me (and i have a full stomach!),

This does successfully leave the field blank but unfortunately doesn't give me any values?

So C2 for example must match "Item List" Name with B2 and "Item List" Account ID with C1.

If there is no match the field must remain blank.

I understand.

But i should have serial_number - FMD0072056 in column C row 35. But there is nothing.

I have no idea what i managed to do, but i copied the formula from your file directly into mine and it works!
You are a genius!!

Thank you so much, saved me hours and hours of boring work.