V+HLOOKUP ...Can't use INDEX

[leechy]

I'm trying to combing vlookup and hlookup.
-Look across ROW2 to find the Ticker i'm looking for
-Look down that SAME COLUMN to find a specific Option.

Can't seem to use the 'INDEX(Yourtable,MATCH(Column),MATCH(Row))" solution I've seen around because there's no 'master y-axis' running down column A that applies to each row -

Once i find the column (easy, HLOOKUP), I need to search for something specific to that Option in the column ...it's not in every other column

Any ideas?
Thanks folks.

[contaminated]

Can u post sample workbook

[DonkeyOte]

Not very clear... care to provide an example ?

What is it you're looking to return from the range - if you're looking to simply return the row in which the "option" appears within the established column you could use:

=MATCH(option,INDEX(YourTable,0,MATCH(Column,$2:$2,0)),0)

the above returning the row within the specified column in which your "option" appears... using 0 in the INDEX essentially creates a Range of all rows in the table but for only a specific column - the MATCH then first against that resulting range... is that what you meant ?

[leechy]

see attached.

[DonkeyOte]

So without being able to test fully (given missing data etc...) you could try altering your range in the VLOOKUP from:

Quotes!$G$5:$G300

to

INDEX(Quotes!$B$5:$G$300,0,MATCH($B8,Quotes!$B$2:$G$2,0))

this way the range is still referencing rows 5:300 but only looks at the appropriate column as determined by code in B8

[leechy]

Thanks for the look folks

[leechy]

I'm still testing it, but i think it WORKS! IT WORKS!!! Thank you so much for this. Cheers.