if anyone knows this well, please get with me now! I'm stuck!

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

I found using the formula wizard the simplest way to create VLookups
when i first started using them.
Adrian's translation of 'excel speak' makes it very simple to
understand so if you think of box one of the formula wizard as the
Lookup range, box 2 as range to look in etc you should get there.


--
penri0_0


------------------------------------------------------------------------
penri0_0's Profile: http://www.excelforum.com/member.php...o&userid=28947
View this thread: http://www.excelforum.com/showthread...hreadid=549332