I have a spreadsheet that has a cell that does a vlookup of a value and looks
in another spreadsheet to pull different data. so spreadsheet A looks like
this:
RACKA and spreadsheet B has RACKA Room1 Panel 4 and once i input RACKA it
pulls information from another speadsheet to give me Room1 Panel 4 and device
name. My problem is that I have RACK A listed several times in Spreadsheet B
but different Panel #'s and different device names but because my array table
is the same it keeps giving the first line of the Array table as the result.
I can change my formula in spreadsheet A for every line but then it would
defeat the purpose of having the formula calculate the result.