Vlookup & match function

Hi,

So this is no good for you ??

=INDEX(Table!$B$2:$D$13,MATCH(Class!C2,Table!$A$2:$A$13,1),MATCH(Class!B2,Table!$B$1:$D$1,0))

VBA Noob

Originally Posted by QQ29

Here is a better link in zip.

thanks

Hi,

In D2

=VLOOKUP(C2,Table!A:D,1+MATCH(B2,Table!B$1:D$1,0),TRUE)

and formula fill down the column

hth
---

Originally Posted by QQ29

can I ask in the VLOOKUP formula, what does "true" stand for? and VBAnoob, i havent tried your formula yet, so i'm not sure if it works or not... but i need to use the VLOOKUP for the assignment.

Hi,

the 'true' says get the closest but not 'more than' match

a 'False' would need an exact match.
hth
---

Thanks Bryan for the help,

If dont mind, i need a little more explanation on the function...
=VLOOKUP(C2,Table!A:D,1+MATCH(B2,Table!B$1:D$1,0), TRUE)

what is the meaning of "1+match"? also, what is the meaning of "0" beside true, other than that, everything else i understand.

I dont want to just enter the info and not knowing what it means, it'll eventually come back to me..if you know what i mean.

thanks everyone as well.

Originally Posted by QQ29

Thanks Bryant for the help,

If dont mind, i need a little more explanation on the function...
=VLOOKUP(C2,Table!A:D,1+MATCH(B2,Table!B$1:D$1,0), TRUE)

what is the meaning of "1+match"? also, what is the meaning of "0" beside true, other than that, everything else i understand.

I dont want to just enter the info and not knowing what it means, it'll eventually come back to me..if you know what i mean.

thanks everyone as well.

=VLOOKUP(C2,Table!A:D,1+MATCH(B2,Table!B$1:D$1,0), TRUE)

=VLOOKUP(

C2, << what to look for

Table!A:D, << where to look

1+MATCH << item to find, but number 1 is the lookup column in Table, the first 'Match' needs column 2 - - so 1+Match

Match(B2,Table!B$1:D$1,0) << 0 is the Match type

, TRUE)

hth
---