Excel formula to know what shelf to put away

[ohmedic88]

Looking to write a formula that will tell someone which shelf to look for something based on the number.

I have excel 2016 and thought of conditional formatting but I run out of colors or symbols to use.

Range		shelf
10049541 <colgroup><col><col></colgroup><tbody> </tbody>	10057181	1
10057183	10057483	2
10057505 <tbody> </tbody>	10057762	3

<tbody>
</tbody>

Shelf	Barcode
1	10049570
2	10057200
2	10057230
3	10057702

<tbody>
</tbody>

What formula can I use to fill in the shelf if the Ranges are in Sheet 2 A2:B20 and the Shelf and Barcode is Sheet 1 A2:B20

Thanks in advance.

Eric

 

[Marcelo Branco]

Eric,

I'm a bit confused about what in your post are data (given) and where are the desired results.
Is the first table (A2:C20 in Sheet2) given and do you want the results in Sheet1 column A, being the column B the search values)?

M.