a double loop?

Hi,

I have a sheet and i want a macro to go down column A until it finds a name then go right until it finds the name of the column.

so on the sheet attached, it would go down a and find Test3 then go along till the column header was example 4 and return the figure 0.7323.

ive got it going down, and then going across but cant get it stop accordin to the column header:

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Code tags added this time

Don't use a Loop, use .Find - it will be much quicker

can you attach a dummy workbook with some data in so that we can see what you are attempting

Loops should be avoided, they are not fast.

Please attach some dummy data & what you want to find

dummy attached.

as you can see it looks for test2 then for example 25 and shows the figure between the 2.

i just cant figure how to get the loop to stop when the column header equals what its searching for.

but now you say use find i'm not sure at all!

cheers