Posted to microsoft.public.excel.programming

Lolly[_2_] Lolly[_2_] is offline

external usenet poster

Posts: 28

problem with vlookup

In one cell of one sheet I have vlookup formula like this
=vlookup($A1,sheet2!$A1:$BC12,4,FALSE)
This formula is absolutely fine . But i have to do this across whole row may
be till BC16. I there a way where I can enter formula in one cell then column
value changes automatically like ,5,FALSE ,6,FALSE

Any help is greatly appreciated
Thanx
--
Kittie

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vlookup Problem	Bruister via OfficeKB.com	Excel Worksheet Functions	0	October 16th 09 01:48 PM
Problem with Vlookup	Confused	Excel Worksheet Functions	10	April 23rd 09 07:20 PM
VLookUP problem	Louise	Excel Worksheet Functions	4	August 23rd 06 04:41 PM
Another vlookup problem	jasmithjr	Excel Worksheet Functions	1	June 27th 06 04:19 AM
VLOOKUP problem with using a -	MrSales	Excel Worksheet Functions	3	May 31st 06 12:05 AM

All times are GMT +1. The time now is 11:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us