I think my question was not clear enough. In VLOOKUP, when we enter column
index number, how do you quickly count the number for column BR. eg. the
table range is a1: BZ100. Then in VLOOKUP function what number do you put for
column BR in the column index number. Do I count all thy from A through BR?
A=1 ,B=2, C=3 ....BR=?

Let m eknow if I'm not clear.
Thanks!

"T. Valko" wrote:

If you have unique column headers then you can use a MATCH function to get
the column_index_number for you.

...........A..........B..........C..........D
1....Name......H1........H2........H3
2....Sue..........x...........y...........z
3....Joe..........a...........b...........c

Where Hn = column headers

To lookup Joe and H2:

=VLOOKUP("Joe",A1:D3,MATCH("H2",A1:D1,0),0)

Result = b

--
Biff
Microsoft Excel MVP


"NM" wrote in message
...
Thanks Sheeloo! With your help I was able to fix my #N/A error.

Another question: What is the fastest way to calculate the column index
number.Say for eg. how do you calculate the column index number for
columns
which fall to the extreme right? I mean my column index is BR, say my
table
range starts from A, what will be the coulmn index number for BR? Do I
count
all the way to BR?

Thanks for your help.

"Sheeloo" wrote:

Suppose you are using
=VLOOKUP(A1,C:D,2,False)

Then make sure that A1 is one of the values in Col C...

If your fourth parameter is TRUE or you are not using one then make sure
that Col C & D are sorted on Col C...

If you are using a formula in A1, then make sure it returns a valid
value...

Just to test replace A1 by 10
and add one row with 10 in Col C and TEST in Col D
you should get TEST as a result of the formula above.


"NM" wrote:

Hi,

I'm using a VLOOKUP formula and I'm getting a #N/A
error! The calculation steps show error at the 'lookup_value'.I've
tried by
best but cannot work through it.Can you please let me know how to get
rid of
this.

Thanks!