now down to business...
I have a vlookup that goes like this:
=VLOOKUP(C$3 & BAHTTEXT($B4), Inventory!A2:B136, 1, f)
where C3= "CA" and B4 = "1"
I basically made a grid that goes from CA -> CZ in a single row (X), and 1 -> 7 in a single column (Y). What I was hoping to do was make a grid that reflected inventory locations on actual racks at my place of work. So the vlookup references a sheet that has 2 columns, 1 with part number data, and 1 with rack location, looks like this:
Code: Select all
Rack Location Part
CB1 CN11447
CB2 CN11312
CB3 C11093
CB3 C12648
CB4 CN7056
CB5 C12602
CC2 CN7476
CC3 CN11079
CC4 CN2101
Code: Select all
CA CB CC CD CE CF
1 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
2 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
3 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
4 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
5 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
6 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
7 #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
-John