VLOOKUP, VCONFUSED

J

Jim

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top