Vlookup
Maybe I can help.
Make sure your data is in adjacent rows and columns. Don't inlcude the
columns headings in your lookup range. The syntax is as follows:
=vlookup(Lookup value, range to look in, number of column to retrieve
result, false)
The "false" on the end is optional, but if you don't use it then you may
retrieve the wrong value. "False" means that the lookup tried to find and
exact match.
The number of columns starts at 1 which is your 1st column or lookup values
and the numbers go across to the right 1, 2, 3, etc.
Hope this helps.
"DoctorMyear" wrote:
if anyone knows this well, please get with me now! I'm stuck!
--
DoctorMyear
|