View Full Version : PO numbers

11-29-2005, 10:06 AM
Hello everybody:

I have two big spreadsheets. Please see a sample attached.

I want to use some formula to insert the po number on sheet 2 to the column C of sheet 1, according to the same invoice numbers on both sheets.

Thank you for your help!

11-29-2005, 10:17 AM
Hi Jane,

Any chance you can alter sheet2 so that 'invoice' is before 'po'? If they were switched, you could use the following to get the PO number:


otherwise, you'll have to use:



11-29-2005, 11:40 AM
or try


2 questions
How big are your spreadsheets as this could influence the method?
Do you need to retain the formula or just need the data?

11-29-2005, 02:56 PM
I tried the sample spreadsheet and it works. However, the big spreadsheet doesn't work. I don't know and will try torrow again. The spread sheet has abount 2000 lines

Thank you very much!

11-29-2005, 03:07 PM
Hi Jane,
I had some problems with your cell formats. It might be worth checking these if you have trouble.