# Excel Basics

<figure><img src="https://3998717274-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F2BHF6WoWT3fDmZodGjU2%2Fuploads%2FhIwJYeXbrHFYGSK8dSJD%2Fimage1.png?alt=media&#x26;token=6819dbe2-491a-429f-b9c6-d61c5cd62015" alt=""><figcaption></figcaption></figure>

***

## Questions

<details>

<summary>Find Revenue</summary>

From the source below can you find the Revenue the specified account?&#x20;

<img src="https://3998717274-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F2BHF6WoWT3fDmZodGjU2%2Fuploads%2F6rIjsWcTfj9qdtfO9HFX%2Fimage2.png?alt=media&#x26;token=323b2c86-deeb-4d6d-94c0-715ee5f2904b" alt="" data-size="original">

**Answer**

This can be solved with a simple VLOOKUP

```
=VLOOKUP(F3,B2:D12,3,FALSE)
```

</details>

<details>

<summary>Find Customer Number</summary>

From the source below can you find the Customer Number corresponding to the Account Name?

&#x20;![](https://3998717274-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F2BHF6WoWT3fDmZodGjU2%2Fuploads%2FKkcX6YMPK8hlJzsWWPzp%2Fimage3.png?alt=media\&token=c828173c-d744-496c-b9ed-142f1f49b3bb)

**Answer**

VLOOKUP won't work as Customer Num is to the LEFT of the Account Name. We need INDEX MATCH [📖Explanation](https://exceljet.net/index-and-match)

```
=INDEX(A2:D12,MATCH(F7,B2:B12),1)
```

</details>

<details>

<summary>Total Revenue</summary>

From the source below can you find the total revenue per sales rep? ![](https://3998717274-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F2BHF6WoWT3fDmZodGjU2%2Fuploads%2F4UsQ6AsIEHOYLcOsTrWR%2Fimage4.png?alt=media\&token=de91d6d7-cd80-4a5a-b9b4-a0f3af8066aa)

**Answer**

This can be solved with a simple SUMIF. For the first row the answer is given below. It will be similar for other rows.

```
=SUMIF(C3:C12,"="&F11,D3:D12)
```

</details>