VLOOKUP within the same workbook???

Orbit121

New Member
Joined
Apr 10, 2002
Messages
3
im trying to use vlookup within the same workbook (different worksheet) and i get nothing

what i am doing
=VLOOKUP(c2,'filename'!'cellname'3)

any ideas???
This message was edited by Orbit121 on 2002-04-11 00:55
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
On 2002-04-11 00:48, Orbit121 wrote:
im trying to use vlookup within the same workbook and i get nothing

what i am doing
=VLOOKUP(c2,'filename'!'cellname'3)

any ideas???

Your formula is incomplete:

=VLOOKUP(lookup-value,lookup-table,column-num,match-type)

is the syntax of the fuction.

Try to find posts related to VLOOKUP by activating Search facility of this board. Consult also Excel's Help file.
 
Upvote 0
I'm not sure what you're trying to do but here is a formula that works:

=VLOOKUP(B11,Suppliers!A2:B32,2,FALSE)

"B11" contains a variable
"Suppliers!A2:B32" contains the sheet name and range to lookup
"2" is the what column you want returned
"False" is an exact match

Hope this helps

Mark
 
Upvote 0
u try using the equal button located at the formula bar then follow the instruction to enter the lookup value, filename, cellname. give a try. excel can allow vlookup on the same work book.
 
Upvote 0
i find the easiest way to get vlookup to work with in same workbook is to add absolute reference:


=VLOOKUP(c2,'filename$'$!'cellname'$3$)
 
Upvote 0
@markbanin i am following the sameway but when i came to worksheet refernce could be change. can u tell me the easy way..

thanks in advance
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,218
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top