Hi folks
im really new to excel & wondered if someone would help me with a formula
exampled below im trying to find "sales order" on sheet 2 within "order number" in sheet 1 IF warehouse error equals True display username, im asuming this is a vlookup formula but i cannot get it to work with my basic knowledge of excel.
Sheet 1
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
im really new to excel & wondered if someone would help me with a formula
exampled below im trying to find "sales order" on sheet 2 within "order number" in sheet 1 IF warehouse error equals True display username, im asuming this is a vlookup formula but i cannot get it to work with my basic knowledge of excel.
Sheet 1
Order number | Warehouse Error | User name | |
TT4002112 | True | (RESULT HERE) | |
<tbody> </tbody> | False |
<tbody>
</tbody>
Sheet 2
Sales Order | user name |
4002112 | micky mouse |
4053763 | daffy duck |
<tbody>
</tbody>