[Fresh New]how to display data from jumped multiple sheet1 columns(e.g. a&d&g...) in sheet2

[tl196]

Hi all,

I'm asked to do a 2-sheets excel for my aunt, in which sheet1 store all the data and sheet2 display the data controlling by the Drop-down list.

Currently I'm facing an issue, as my aunt want the data store in sheet1 in specific format (invoice|job|details of charges|revenue|outlay|details of charges|revenue|outlay|details of charges|revenue|outlay...etc), I cant do it easily in way of define and name and vlookup them.

I'm new to excel and the forum, I have no idea of how to do this. Please can anyone help? I'd upload the photos with an ideal output example in sheet3 using jn1 as standard.

Thanks a lot!

 

[Rijnsent]

Hi there,
welcome to the forum! I'd use a simple VLOOKUP for that. Something like =VLOOKUP(C1,YourSheetName!$B$2:$AZ$100;3;FALSE) for your first value. For the other items, you'd only change that number 3 to 4, 5, etc. The first "line" of your data is 3-5, the next one 6-8, the next 9-11, etc.
Hope that works,
Koen