Forum Discussion
how to use vlookup to list data in multiple columns of a different sheet
I'm trying to do the data storage and a clear data display in 2 sheets, in which it will work as example below: Sheet 1(details| revenue| outlay repeat about 20 times) invoice| details| revenue|...
Tony
can you supply an example spreadsheet as it is difficult to understand your problem based on just the text.
Peter
it's something like this, sheet1 store the data horizontally, and sheet2 display the data according to the job number selected in the drop-down menu.
sheet3 is the example using jn1 as the selected one
many thx
Hi Tony,
I have come up with a possible solution using the OFFSET command and a rather convoluted formula - but it seems to work.
I am not sure how you get your source data (is it manual?) but you might want to consider changing the format to make it easier to manipulate?
Anyway if you are happy with the solution please mark it as complete.
many thanks,
Peter
