Extract data in specific row/column?

I have a list of date(sample attached), where I need to search for the value in column A, search for another value in row 1, and then obtain the values in the corresponding cell, plus the next 2 below it. I need each of these values assigned to separate strings. Any ideas?

So for example, in the attached sample, I would like to search for "value 1", then, find "Test 1" in the first row. Next, assign string A=21500.6, B=555, C=2323. Almost like a vlookup+hlookup?

maybe formula (see attachment)

Well I need to implement it into a VBA code I already have, so if possible, I need it done with VBA coding.

Edit:

A,B,C are strings that I have declared in my VBA code.

Is there a way I can use the Index Match function in VBA? I didn't think there was, but perhaps I can use the Find function somehow?

try it

Please Login or Register  to view this content.

Great thank you! I got it to work.