Hi all, this is a first post so appologies if I break any forum etiquette.

I currently have a list containing category, x variable, y variable (columns A, B, and C). I would like to look up two percentile values and place them in columns E and F.

The problem is the two lists (of values and percentiles) which I would hope to perform vlookups off of, depend upon fairly complex forumlas and a data validation cell. I was wondering if there is a way to change the data validation cel (to whatever category is in column A), perform the lookups, paste the values, then skip to the next row, change the data validation box again, perform the lookups, paste values, etc...

I would prefer to do this without VBA if there is a way. I thought of using address and indirect functions as well, but this would require me to paste long lists of each of my categories.

Thanks a ton.