VLookup with Variable Column Formula

[Nlich]

Hi guys,

I'm a bit stumped and have been trying to figure out how to solve this issue for a little while so i thought i'd post it up.

I believe i need a variation of a vlookup to consolidate some data into the one sheet, and perform the task in the future.

I have an example which will assist in understanding my question.

I need to show in C2 the number of transit days when an item is shipped from source DC "DC1", "DC2", or "DC3" to the Destination Postcodes, as per the Transit Days spreadsheet.

For example, C2 should display the number of transit days an item takes when going from "DC1" to Destination Postcode "1029" which is, 2.

Hopefully i have explained this sufficiently (i did struggle a little bit sorry!!) and i would be grateful if anyone could help!

Thanks all!!

[MarvinP]

Hi Niche and welcome to the forum,

Could you edit your thread title, so we can find it again. There are SO many threads using your exact phrase... How about "VLookup with Variable Column Formula"

Find the attached with your answer.

[sktneer]

Try this.....

Please Login or Register  to view this content.

[Nlich]

Thank-you so much for your help Marvin! Brilliant And i have edited the thread title.
Thanks for your reply too Sktneer.