Resolved >>> Vlookup

[mitelkm]

Hi guys!!! thanks for my vlookup & if help about 10 mins ago .. it worked!! Now one more question .. I noticed

if I am looking up column a, to give me column c's value, it returns b's column.. does a vlook up only work when the columns are side by side :

=IF(ISNA(VLOOKUP(D22,'OGS SCHEDULE A'!A:C,2,FALSE)),"0",VLOOKUP(D22,'OGS SCHEDULE A'!A:C,2,FALSE))


I want to look in column A for column C values, but instead get column b values???

[oldchippy]

=IF(ISNA(VLOOKUP(D22,'OGS SCHEDULE A'!A:C,2,FALSE)),"0",VLOOKUP(D22,'OGS SCHEDULE A'!A:C,2,FALSE))

Try changing the 2 to 3, the third column rather than the second

[mitelkm]

You're a geniius!!! Thanks so much!!

[oldchippy]

Glad it worked for you - If you want to no more, take a look at this link

http://www.contextures.com/xlFunctions02.html