Vlookup query

[Dnyan]

Hi,

I want to know how to find information using Vlookup. I have a file in which Days mentinoed in the end of the tabel but unable to get answer. please find attached file for example.

[benishiryo]

hi Dnyan, here's how people usually use VLOOKUP. you have 2 lists of data. both list have a common unique ID. and say, List1 has got no Amount but has other info you need. List 2 has got amount, but no other info. then you can use VLOOKUP to look for the unique ID in List2 & return the amount to List1.

in your eg, you only have 1 list. why would you want to return a data in the list that you already have in your data. and days are certainly not unique because Tuesday appeared twice.

let's just assume i have another list which has a cell in Sheet2!A1 named "Tuesday". I want to lookup in your list & return column F amounts. so i will use in B1 in that list:
=VLOOKUP(A1,Sheet1!C2:F12,4,0)

A1 = the "Tuesday" in my Sheet2
Sheet1!C2:F12 = the list you have (C2 because that is where Tuesday is found. VLOOKUP can only lookup from the left to the right. column F is where my desired data is)
4 = Column F is the 4th column from C
0 = Exact match

so if you do not have a unique ID, the VLOOKUP only returns the 1st value if finds. just for your information, INDEX formula can look backwards if you need it

[Pete_UK]

VLOOKUP works by looking through the LEFTmost column of the table searching for a match with your lookup_value. You would probably have to use an INDEX/MATCH combination, but I'm not sure what it is you want to do.

Pete

[Dnyan]

VLOOKUP works by looking through the LEFTmost column of the table searching for a match with your lookup_value. You would probably have to use an INDEX/MATCH combination, but I'm not sure what it is you want to do.

Pete

Yes u r correct, I want to calculate from right to left so is it possible?