How to find data in column and Row

[mtheriault2000]

Hello

A blank for me

I got a series of data like

iInstrument	iScale	iActualOpen	iActual_High	iActual_Low	iActualLast	iLastOpen
EUR.USD	3 Minutes	1.42315	1.42445	1.42275	1.42420	1.42410

Data are placed in 2 row, where the name of the variable is above the value that I'm looking for

In VBA, If I want to found the value of "iInstrument", result should be "Eur,Usd" for the data provided

Hope I'm clear enough

Martin

 

[stnkynts]

Not clear at all. How do you want to enter your search string? In an input box? Do you always need to return the value 1 cell below your search string? What do you want to do with the returned value? Display it in a message box?

 

[mtheriault2000]

Hello stnkynts

Excuse me for not being clear. My English is not perfect and I loose my idea when translating

The information showed was copied from my sheet. unfortunately it is not well formatted on this page. The data is a table where the upper line is the variable name and the lower line is value

I will try to found a way to post it as a table

Martin