Returning the Range value for specific text within a list of Data

Hi

I am setting up multiple vlookups table arrays in one data set to make a recurring process easier, however the data will increase going forward (which I want to be able to copy and paste values into) which will mean that all the table arrays I have set up will be in the wrong areas. Is there a quick way to do this?
If there was a formula which would tell me what range (row numbers) specific text was in a column I would be quickly able to re-jig my formulae and be confident of them being right

Eg of data set

Text Number Number
AAA 1111 3333
AAA 1121 3334
AAA 1131 3335
BBB 1111 3333
BBB 1121 3334
BBB 1131 3335
BBB 1111 3333
CCC 1121 3334
CCC 1131 3335

When this gets larger there maybe 10 rows of AAA and 7 of BBB, but my original table arrays are set to the first 3 rows for my AAA search and row 4-7 for my BBB search, which will mean I am taking data from the wrong row

Anybody have any help on this one?

Thanks
WM7

Hi

Why are you setting up multiple lookup arrays? Just use the entire columns?

If there is a specific reason, then can you set up an example workbook so we can see what you are working with.

rylo

Thanks for your reply

I cant add an attachment but below is what it looks like

Data sheet

Month
201107 201108 201109 201110 201111 201112 201201 201202
Job Type Client Figures Figures Figures Figures Figures Figures Figures Figures
1 AAA xxx xxx xxx xxx xxx xxx xxx xxx
4 BBB xxx xxx xxx xxx xxx xxx xxx xxx
4 DDD xxx xxx xxx xxx xxx xxx xxx xxx vlookup array
4 EEE xxx xxx xxx xxx xxx xxx xxx xxx
4 FFF xxx xxx xxx xxx xxx xxx xxx xxx
3 AAA xxx xxx xxx xxx xxx xxx xxx xxx
5 BBB xxx xxx xxx xxx xxx xxx xxx xxx
5 CCC xxx xxx xxx xxx xxx xxx xxx xxx
6 AAA xxx xxx xxx xxx xxx xxx xxx xxx vlookup array
6 BBB xxx xxx xxx xxx xxx xxx xxx xxx
6 DDD xxx xxx xxx xxx xxx xxx xxx xxx
2 BBB xxx xxx xxx xxx xxx xxx xxx xxx
7 BBB xxx xxx xxx xxx xxx xxx xxx xxx
8 FFF xxx xxx xxx xxx xxx xxx xxx xxx






I have been sorting by job type then using a vlookup based on a section

Working sheet
Month
201107 201107 201108 201108
Client Job Type (Amalgamation of codes from Data worksheet) Budget Figures Budget Figures
AAA 1+4 xxx Want to link back to the data xxx Want to link back to the data
AAA 3+6+5 xxx Want to link back to the data xxx Want to link back to the data
AAA 7+2 xxx Want to link back to the data xxx Want to link back to the data
BBB 8 xxx Want to link back to the data xxx Want to link back to the data
BBB 3+6+5 xxx Want to link back to the data xxx Want to link back to the data
BBB 7+2 xxx Want to link back to the data xxx Want to link back to the data
BBB 1+4 xxx Want to link back to the data xxx Want to link back to the data
CCC 3+6+5 xxx Want to link back to the data xxx Want to link back to the data
DDD 7+2 xxx Want to link back to the data xxx Want to link back to the data
DDD 8 xxx Want to link back to the data xxx Want to link back to the data
EEE 7+2 xxx Want to link back to the data xxx Want to link back to the data
FFF 1+4 xxx Want to link back to the data xxx Want to link back to the data
FFF 7+2 xxx Want to link back to the data xxx Want to link back to the data



The reason is because there are two variables to my lookups in the same data

I am trying set up a template to lookup info by lets say job type (variable) for client name (variable) from the same data set but at the same time the data set has too many job types that I need to condense for ease of presentation.

Maybe vlookups aren't the best tool to use, but I have it working on the current set of dat using a long vlookup formula, but I will have problems when the data set grows which will misalign the table arrays

Hi

What is the problem with adding an example file?

rylo

The drag and drop thingy doesn't work for me - is there some trick to getting the icon attached after uploading it?

Hi

try adding the file using the browse option instead of the drag and drop.

rylo