| View previous topic :: View next topic |
| Author |
Message |
jitin_21
Power User
Joined: 28 May 2007
Posts: 93
Location: New Delhi
|
|
| Back to top |
|
 |
ozzie
OOo Advocate
Joined: 29 Jul 2010
Posts: 316
Location: victoria
|
 Posted: Thu Feb 10, 2011 10:00 pm Post subject: |
 |
|
formula should be
| Code: | | =VLOOKUP(B2;Sheet1.A1:D87;4;1) |
if this has answered your question please add "[Solved]" to the beginning of your first post title (edit button), that would save the busy people from looking in and perhaps interest learners like myself who are always looking for answers . |
|
| Back to top |
|
|
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1851
Location: Sydney, Australia
|
| Posted: Thu Feb 10, 2011 10:20 pm Post subject: |
|
|
Sheet1 column B is the lookup column, not column A, so try...
| Code: | | =VLOOKUP(B2;$Sheet1.$B$1:$D$87;3;0) |
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
jitin_21
Power User
Joined: 28 May 2007
Posts: 93
Location: New Delhi
|
| Posted: Thu Feb 10, 2011 10:41 pm Post subject: |
|
|
| ken johnson wrote: | Sheet1 column B is the lookup column, not column A, so try...
| Code: | | =VLOOKUP(B2;$Sheet1.$B$1:$D$87;3;0) |
Ken Johnson |
@Ken, but in earlier versions it was not like this. we could define any range and look the values.
_________________
Jitin
Using OOo2.X & 3.X on Windows or Linux |
|
| Back to top |
|
|
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1851
Location: Sydney, Australia
|
| Posted: Thu Feb 10, 2011 10:49 pm Post subject: |
|
|
| jitin_21 wrote: | | @Ken, but in earlier versions it was not like this. we could define any range and look the values. |
I don't think you're correct there.
How would these earlier versions of VLOOKUP know which column to lookup when searching the table?
I have only ever known VLOOKUP tables to have the searched column being the table's left-most column.
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
ozzie
OOo Advocate
Joined: 29 Jul 2010
Posts: 316
Location: victoria
|
| Posted: Fri Feb 11, 2011 7:06 pm Post subject: |
|
|
I didn't think
I didn't look
I didn't check
My apologies |
|
| Back to top |
|
|
|
