if the value in B2 will only be in one of the tables try
=if($B2="","",IF(ISNA(VLOOKUP(B2,'Sheet1'!$B$8:$G$ 57,6,0),0,VLOOKUP(B2,'Sheet1'!$B$8:$G$57,6,0))+IF( ISNA(VLOOKUP(B2,'Sheet1'!$K$8:$P$57,6,0)),0,VLOOKU P(B2,'Sheet1'!$K$8:$P$57,6,0))+ ...)
If it is text change the ,0, to ,"", and the + to &

if it can be in several groups and yo have a priority, you could use a
helper column with if(isna(vlookup() for each group and select just the first
one which shows

"Bigfoot17" wrote:

I have reviewed every Vlookup post and I don't think I have seen this type of
question.

I have "groups of information" on Sheet 1:
Columns B-G, K-P, T-Y, AC-AH, AL-AQ, AU-AZ, BD-BZ, BM-BR, BV-CA

What I want to do is lookup on Sheet1 a Value in Column B and return the
value in G. But if the value is not in B look it up in K, if it isn't there
look it up in T, etc.

Here is what I have for looking the value up in the first two groups, but I
cannot get my arms around how to do this for 9-11 areas:
IF($B2="","",IF(ISNA(VLOOKUP(B2,'Sheet1'!$B$8:$G$5 7,6,0)),VLOOKUP(B2,'Sheet1'!$K$8:$P$57,6,0),VLOOKU P(B2,'Sheet1'!$B$8:$G$57,6,0)))

Any assistance is appreciated. Ususally it takes me longer to explain the
problem than for someone to assist.