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 fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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,543
Messages
6,114,240
Members
448,555
Latest member
RobertJones1986

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