Vlookup Help
So Ben have all your questions been answered or do you still need some help?
"Ben" wrote:
Thank you for your input BJ. The necessary components (function arguments
dialog box) were not helpful at all as i wasnt able to select my other excel
document.
I do apologise if i came across a bit crude and canny, however, I like to
understand in the inns and out's of what i am actually learning. - I am not
just looking for an easy way out. I know it is incredible helpful having
these rewarded chaps here and i am grateful and understand that everyone else
is also in need of help.
However, would it honestly take more than 5 minutes for an excel expert to
share their own independent knowledge and not give a textbook answer? The
syntax site regarding Vlookups helped obviously as my first attempt (above)
did come close to a doable attempt but some other valid explanation would
have been nice.
I do appreciate the help received. Honestly i do, but i just want to
understand what it is i am specifically using within the spreadsheet. I also
thought that Microsoft wouldnt mind helping those who want to learn more
about their software. Hence all the questions.
I do apologise again.
Regards & Gratitude,
Ben
"BJ" wrote:
I would suggest going to your formula in your worksheet and while you have
the cell highlighted click on the 'Insert Function' button [the 'fx' symbol
just to the left of the cell entry area]. This will show you in a separate
dialog box the Function Arguments of your formula. You can then select
components of the formula by clicking in the cell entry and the matching
function along with its result "=" will be highlighted in the dialog box.
By doing this you can see if you have all of the necessary components of a
function and if they are working as you had hoped they would.
The formula results you get can generally be deciphered from the MS Help
function. For instance, if you receive a #REF! result, the column index
number is greater than the number of columns in the array - as was the case
in your first posted example when you changed the "1" to a "2".
The folks on this board are extremely helpful but they generally answer what
your question requests - as you can see there are hundreds of questions asked
daily and they can only do so much. Your post asked if you could "do" a
certain function and you received the reply that "yes, that is doable." If
you wanted a more in-depth explanation then ask for it ... the folks here,
whether MVPs (who are not representatives of MS) are always willing to
dispense their vast stores of knowledge on the rest of us dolts ...
You'll get a lot further with sugar than you will with vinegar ...
|