VLOOKUP within the same workbook???

Orbit121 · Apr 11th, 2002, 05:48 AM

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 ]

Aladin Akyurek · Apr 11th, 2002, 06:02 AM

Quote:

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.

markbanin · Apr 11th, 2002, 06:04 AM

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

apple · Apr 11th, 2002, 06:12 AM

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.

Orbit121 · Apr 11th, 2002, 08:38 AM

To everyone on here, thank you very very much, you all helped!!!!!!

you guys kick some ***!

dtaylor · Apr 13th, 2002, 06:05 PM

i find the easiest way to get vlookup to work with in same workbook is to add absolute reference:

=VLOOKUP(c2,'filename$'$!'cellname'$3$)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 05:48 AM	#1
Orbit121 Join Date: Apr 2002 Posts: 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 ]

Apr 11th, 2002, 06:04 AM	#3
markbanin Join Date: Mar 2002 Posts: 14	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

Apr 11th, 2002, 06:12 AM	#4
apple Join Date: Mar 2002 Location: web Posts: 8	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.

Apr 11th, 2002, 08:38 AM	#5
Orbit121 Join Date: Apr 2002 Posts: 3	To everyone on here, thank you very very much, you all helped!!!!!! you guys kick some ***!

Apr 13th, 2002, 06:05 PM	#6
dtaylor Join Date: Mar 2002 Location: So Cal Posts: 380	i find the easiest way to get vlookup to work with in same workbook is to add absolute reference: =VLOOKUP(c2,'filename$'$!'cellname'$3$)