Search results

Great, thank you. I haven't tested this but from looking at it the formula makes sense. The spreadsheet is being built on 2007 but I am converting it to 2003 compatible mode as it's being sent on elsewhere and I think they may have an earlier version. Thanks again all!

Narayank Thanks so much. Managed to get your formula to work on my work PC. I was being a bit thick actually...firstly I hadn't been using the Control Shift Enter properly and secondly (doh) it was returning #N/A as my sample data did not have a returnable value i.e the tran number didn't...

Ah right, thanks guys. I think I need to have a go at home as when I right click at work no 'download file' option comes up, which is probably to do with the firewall.

Hi Sorry, I'm new to this, do I need to join speedy share to look at your file?

Hi Narayan, sorry tried yours again using Control Shift Enter instead of just enter and it said the formula had an error too.

Hi Kaushik I tried yours and it didn't work as it says there are too many arguments. I will be stating within my formula =(cell value) rather than 123 but that's easily amended. Thanks anyway

Looks like it will work in theory. Thanks so much I'll try it at home where I have my spreadie. I just tried it out on a dummy spreadsheet at work and it seems to be returning #N/A. Sorry to sound like a numpty but what do you mean by entering it as an array formula with C, S and E?

Hi If in my first column (say A) I have multiple listings of a transaction number, yet in column B I only have occasional listings of a PO number, how can I get Excel to look up the transaction number and return the PO number on the assumption that the PO may not necessarily be the first item...