That is my problem. I don't want to change every formula in the 1st
spreadsheet. Can the formula have the array table from the other spreadsheet
increment by one if i copy it down the column. Or can i do something like if
column A is found in Spreadsheet B then look at column B and search
Spreadsheet B to find a match and place the value.

"Gary''s Student" wrote:

VLOOKUP is a good way to find the FIRST occurance of an item in the table.
To get ALL the occurances, the usual technique is to use AutoFIlter on the
table and copy over the results. This is not really automatic.

If the table includes row information, then it is possible to create a set
of cascading VLOOKUP formulas.

The first VLOOKUP would cover the entire table, the second VLOOKUP would
begin one row below what the first one found, etc.
--
Gary''s Student - gsnu200751


"DV" wrote:

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.