I think you could insert a new column A and use 1,2,3.1000 to label rows
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Sunday, August 28, 2011 7:18 PM
Subject: Re: $$Excel-Macros$$ VLOOKUP or Similiar
Dear Cab,
If possible please provide a sample sheet..
On Mon, Aug 29
Hi Noorain
I have tried it using normal vlookup and it works great.I thought that
in the column that the number is searched in had to be a column with no
blanks. I had not tried when I sent email. Have tried now and it is ok.
Apologies for taking up your time.
Regards
Charlie
On Mon, Aug
Dear Cab,
If possible please provide a sample sheet..
On Mon, Aug 29, 2011 at 4:22 AM, Cab Boose wrote:
> Hi
>
>
> I have a list of data 5 columns 1000 rows. There are some blank rows in
> this list. Sometimes one sometimes several. I do not want to delete the
> rows.
> I want a vlookup functi
Hi
I have a list of data 5 columns 1000 rows. There are some blank rows in this
list. Sometimes one sometimes several. I do not want to delete the rows.
I want a vlookup function or similiar, to lookup column A for the required
number and copy into normal cell where formula is. That is: just a n