Hi, i was wondering if anyone could asssit me with a problem i'm having?
The problem is that i have country marked on sheet 'Air data' in J2 which i
am trying to use to look up a figure from a chart with, on sheet 'New agreed
rates' in which coloumn A has the list of countries to choose from and row 16
has the headings of the table (full table range A16:I73) what i am trying to
do is get a formula that picks the country name from 'Air data' J2 and
matches the row on the table but to pull the coloum number i am trying to get
a word or number from 'air data' O2. i have been trying the below formula

=VLOOKUP('Air data'!J2,'New agreed rates'!A17:I73,(HLOOKUP('Air
data'!O2,'New agreed rates'!A16:I73,1,FALSE)),FALSE)

I'm not sure about using the Hlookup to get the row index num for the
vlookup and what to use as the hlookup's row index number?

Can anyone see what i'm doing wrong, as i'm tearing my hair out and there
ain't that much there to begin with!! If i haven't given enough details then
please let me know and i can elaborate. Thanks for any assistance offered

--
Jim

You can use MATCH to get the column number..The MATCH formula lookup 'Air
data'!O2 in the header row A16:I16 and will return the column number...

=VLOOKUP('Air data'!J2,'New agreed rates'!A17:I73,
MATCH('Air data'!O2,'New agreed rates'!A16:I16,0),FALSE)


If this post helps click Yes
---------------
Jacob Skaria


"Jim" wrote:

Hi, i was wondering if anyone could asssit me with a problem i'm having?
The problem is that i have country marked on sheet 'Air data' in J2 which i
am trying to use to look up a figure from a chart with, on sheet 'New agreed
rates' in which coloumn A has the list of countries to choose from and row 16
has the headings of the table (full table range A16:I73) what i am trying to
do is get a formula that picks the country name from 'Air data' J2 and
matches the row on the table but to pull the coloum number i am trying to get
a word or number from 'air data' O2. i have been trying the below formula

=VLOOKUP('Air data'!J2,'New agreed rates'!A17:I73,(HLOOKUP('Air
data'!O2,'New agreed rates'!A16:I73,1,FALSE)),FALSE)

I'm not sure about using the Hlookup to get the row index num for the
vlookup and what to use as the hlookup's row index number?

Can anyone see what i'm doing wrong, as i'm tearing my hair out and there
ain't that much there to begin with!! If i haven't given enough details then
please let me know and i can elaborate. Thanks for any assistance offered

--
Jim

Jacob, thank you ever so much, worked like a charm.
:-)

--
Jim


"Jacob Skaria" wrote:

You can use MATCH to get the column number..The MATCH formula lookup 'Air
data'!O2 in the header row A16:I16 and will return the column number...

=VLOOKUP('Air data'!J2,'New agreed rates'!A17:I73,
MATCH('Air data'!O2,'New agreed rates'!A16:I16,0),FALSE)


If this post helps click Yes
---------------
Jacob Skaria


"Jim" wrote:

Hi, i was wondering if anyone could asssit me with a problem i'm having?
The problem is that i have country marked on sheet 'Air data' in J2 which i
am trying to use to look up a figure from a chart with, on sheet 'New agreed
rates' in which coloumn A has the list of countries to choose from and row 16
has the headings of the table (full table range A16:I73) what i am trying to
do is get a formula that picks the country name from 'Air data' J2 and
matches the row on the table but to pull the coloum number i am trying to get
a word or number from 'air data' O2. i have been trying the below formula

=VLOOKUP('Air data'!J2,'New agreed rates'!A17:I73,(HLOOKUP('Air
data'!O2,'New agreed rates'!A16:I73,1,FALSE)),FALSE)

I'm not sure about using the Hlookup to get the row index num for the
vlookup and what to use as the hlookup's row index number?

Can anyone see what i'm doing wrong, as i'm tearing my hair out and there
ain't that much there to begin with!! If i haven't given enough details then
please let me know and i can elaborate. Thanks for any assistance offered

--
Jim