ansaurus

Question

Match value from a table and print the results on a column

Answer 1

A:

TerrorAustralis 2009-10-30 03:14:23

Your first part is correct...."column A" is my reference on the table and the corresponding values are on (column B)" column F" is my output... "column D" is my request...so the plan is... if I want to get the output for a few numbers I past the numbers on "column D".... it will search and match with column A... when it finds it will grab what ever is on "column B" and paste on "column F"It is same as the lookup formula... I have a number on "column D" it will lookup on "column A"... if is a match will grab the value on "column B" and print on "column F"...

2009-11-01 23:01:25

I reason that lookup does not work for me is because on gives me the first matching value that finds on "column A"...it does not keeo searching for the next matching value... by the way "column D" and "column F" they don't match...."column D" is my input... "column F" is my output.... and of course "column A" and "column B" are part of the table.... Thanks for your time..Cheers JFC

2009-11-01 23:10:34

The only excel way to do this is VBA. When you want more than one cell to be changed by an operation you need a macro. The macro you are after is a For Each loop on Each Range in Column A. If the cell is the value you are looking for, get the value in column B, paste it into column F, continue. Code pasted below

TerrorAustralis 2009-11-02 02:22:00

VBA macro above. You can change the columns by changing the variables ending in Col, comments in the code should explain this

TerrorAustralis 2009-11-02 02:41:25

Thanks a million... it scans over 14 thousand plus rows very fast ..were use to take hours and hours to do the same manually ....this is supper fantastic... thanks again.. cheers JFC

2009-11-02 04:30:22

No prob, performance is about as good as i can get it, but if you want i can add a few small incremental gains for thousand column scans

TerrorAustralis 2009-11-02 04:47:52

No... this is perfect... thanks again for you time...Cheers, JFC

2009-11-02 07:45:14

ansaurus

tags:

views:

answers:

Match value from a table and print the results on a column

related questions