PDA

View Full Version : Excel, VLookups


DarkDestroyer
04-25-06, 10:23 AM
Hey guys,

I know its prob rlly easy but im having real trouble with Vlookup tables in excel, i have my table set up to lookup and i also have my data to test.

however i just cant get it to pull the correct value from the table...it seems to take only the first coloums details...

owen
04-25-06, 10:28 AM
In the LOOKUP_VALUE box, type percent, the label at the top of the column containing the value you want to look up.

In the TABLE-ARRAY box, type the label you want

In the COL_INDEX_NUM box type the number of the coloumn that contains your data

Click OK

Copy the formula down the column,

OK

DarkDestroyer
04-25-06, 10:31 AM
Ah ok, thnx ye if i change that coloum number it goes along and selects the right one.

Thanks a lot