# Look up a location in reverse

Read every code row your file lists at an exact rack.

Source: https://help.smartfact.ai/findbench/guides/reverse-lookup

Audience: Operator

## Look up a location in reverse

1. **Start a lookup**

   Start a lookup.

   FindBench reads the local reference you choose. It does not fetch stock data or confirm where goods are now. All values in this lesson are synthetic.

2. **Choose the prepared reference CSV**

   Choose the prepared reference CSV.

   This prepared CSV enters the real file chooser. Review the rows and choose the columns before loading. Nothing has been uploaded.

3. **Map the exact code column**

   Map the exact code column.

   Choose Part as the code column. Every value stays exact text, including leading zeroes.

4. **Map the description column**

   Map the description column.

   Choose Text for the descriptions. Different descriptions for one code remain visible.

5. **Map every listed location**

   Map every listed location.

   Choose Bin for locations. Repeated rows are retained, and a blank location stays explicitly not supplied.

6. **Keep the relevant note column**

   Keep the relevant note column.

   Choose Comment for notes. The Ignore column is left out and will not be saved with the reference.

7. **Name the reference**

   Name the reference.

   A clear title appears with the lookup, downloads and saved work. It is your declared context, not a verified authority.

8. **Declare when the reference was prepared**

   Declare when the reference was prepared.

   This date comes from the file owner. Loading it today does not prove it is current.

9. **Load the reviewed reference**

   Load the reviewed reference.

   Load all six mapped rows. The original file and excluded column are discarded; the exact mapped values and row numbers remain.

10. **Change to a location lookup**

   Change to a location lookup.

   Reverse lookup finds all codes listed against an exact location. Changing direction clears any previous answer.

11. **Read all codes listed at this rack**

   Read all codes listed at this rack.

   RACK-B has two rows with conflicting descriptions. A listed rack is source-file information, not proof that the part is there now.

[Watch or practise this chapter](https://help.smartfact.ai/findbench/demo?guide=reverse-lookup&chapter=reverse-lookup)
