Look up originating post code

**marklister** · 02-06-2012, 07:04 AM

I have a set of data that contains a unique identifier being a consignment number, against each of these is a leg number showing how many times this is moved. What I need to be able to show is the originating postcode as highlighted yellow on the attached sheet by looking up leg number 1 against the consignment number. Is there an easy way of doing this?

Thanks in advance.

Mark

**Fotis1991** · 02-06-2012, 07:13 AM

Hi Mark and welcome to the forum.

If i understand well your point, then you can do it, using Conditional Formatting.

Hope to helps you.

**marklister** · 02-06-2012, 07:18 AM

Hi, thanks for your response. However, I would like the originating postcode to be automatically entered in to this column by looking up against leg and consignment.

**Fotis1991** · 02-06-2012, 07:32 AM

...Then, something like this?

=IF(C3=1;E3;IF(C3<>1;G2))

**marklister** · 02-06-2012, 08:45 AM

That works great thanks but what should the formula look like if I then wanted the last postcode, ie against leg 3 or leg 5 etc.

Thanks

**Fotis1991** · 02-06-2012, 09:11 AM

You are welcome.

Sorry, but my poor English, don't let me to understand your new question..

**marklister** · 02-06-2012, 09:21 AM

0226.xls

I have attached your file showing what should be dispayed.

Thanks

**Fotis1991** · 02-06-2012, 09:38 AM

Mark, i really want to help you, but for me, makes no sense..

Sorry!

**marklister** · 02-06-2012, 10:47 AM

Thanks, I have managed to get the answer I want be writing the following formula but don't know if there is a simpler way to achieve the same result.

=if(iserror(if(a3=a4,large(c:c,e3),h3)),i4,if(a3=a4,large(c:c,e3),h3))

Mark

0226.xls