Moving data from one sheet to the next (VLOOKUP?)

[GriffonOki]

Hello all,
Been looking through the forum for awhile now and got a couple of ideas but am new to doing something like this in excel. I have an extremely large spreadsheet with with an individual ID number for each file, located in the same colum. They are not in numeric order and I cannot sort them as this will mess up the structure that it is representing. I have another sheet, with the same ID numbers and one cell of info, a footnote, that I want to be able to see at the end of each file on the first sheet. The footnotes may be the same for several different IDs. Not every record has a footnote. I would like to make a formula that I can fill all the way down to the bottom of the sheet, some 6000 lines. These are both located in the same book. Any help would be appreciated. Not really sure on how to start. Tried a couple of if statements but that didn't work.
Thanks

[GriffonOki]

I think VLOOKUP may work but my problem now seems to be that as you move down the column so does the search criteria. Is there a way to keep that the same? It seems that it doesn't want to create duplicate footnotes either. Should I put a "True" at the end of this statement?
=VLOOKUP(A4,Pages!A2:B39,2,FALSE)

[ratcat]

G'day and welcome to the forum

Try this

=VLOOKUP(A4,Pages!$A$2:$B$39,2,FALSE)

[GriffonOki]

Thanks for the Welcome and the speedy reply.
That was just what I needed. I'll certainly come back for more info.
Thanks again, Griff

[GriffonOki]

Well I got to work this morning thinking I was good to go with the formula above only to punch it in and it doesn't work. This is what I'm using:
=VLOOKUP(D4, Footnotes!$A$1:$B$2566, 2, FALSE)
The formula doesn't seem to be doing anything. It fills out the cell that I type it into and sits there not returning anything. I'm working in Excel 2003. I went into the reference table, Footnotes sheet, and made sure that the first column is sorted in ascending order.
Not sure if this makes a difference. D4 is referencing an ID like this: M6710000923

[ratcat]

G'day

The cell with the formula display a blank cell or is there an error displayed ?

It might be best to upload a tiny example excluding sensitive information.

Cheers

RC

[GriffonOki]

ratcat
I've included an example. There is no return on the formula. The cell shows the formula as written. It's probably some simple thing that I'm doing wrong but my buddy and I can't figure it out.
Thanks for the help.

[martindwilson]

i does work but the column is formatted as text, select the column then data/text to columns and just click finish

[ratcat]

G'day

Yep it was something simply. The format of the cells is text. Click on the first with the formula then right click then select 'Format Cell' then select 'General' then OK. *** Then you will have to copy drag the formula down.

Cheers

RC

Edit: *** Click in the formula bar and press enter

[GriffonOki]

Thanks guys, changed the formatting and it worked. Saves me a couple of days of keyboard punching. Now I'd just like to get rid of the #NA but I saw some other threads addressing that.
Once again Thanks.

[ratcat]

G'day Griff,

Try this

Please Login or Register  to view this content.

Cheers

RC