Excel Data Lookup Question?

Question

I'm looking for info on Excel (taking too long on Excel blog) for returning value from another worksheet without using VBA.

Here is the formula i used, and it returns #N/A
=VLOOKUP(B1,BinList!$A$1:$B$7,1)

Answer 1

This help?
I am looking for a formula that will look at an adjacent column then find that value in another sheet and return the data from an adjacent column.
=VLOOKUP(A2,Sheet2!A2:B100,2,FALSE)

http://www.contextures.com/xlfaqFun.html#Vlookup

Answer 2

Here are the two possible problems that I know of.

First do you have a worksheet within your workbook named "BinList" - check the spelling. Check that the sheet named BinList doesn't have a trailing space in the name. The #NA error may mean that Excel cannot find a sheet named "BinList"

I've also found that correcting the sheet name doesn't automatically get rid of the #NA. Retype "BinList" in the formula and enter.

Second, do you have data in cells A1 through A7 of the BinList sheet. If they are all blank, you will get the #NA error.

By the way, in your lookup formula, you have a "1" at the end, indicating the col. no. of the value you want returned. You probably want "2", because 1 will just return the value in B1 which you looked up.

Finally, if you want the formula to return #NA if it doesn't find an exact match, after the 2, enter ",FALSE" (without the quotes). The way your formula is now written, if your lookup value is not in cells A1:A7 of the table, it will match on the largest value that is less than or equal to the lookup value.

Answer 3

i dont know what exactly ur asking for.

may be u must checkout this site www.excelgoodies.com

there would be somone online in chat to help you on this