Need to reference cells from one sheet to another but in opposite direction - transpose???

**surveyingdriller** · 08-25-2019, 02:40 PM

Hello All,

I have a sample workbook attached. What I am doing is trying to get cells in Sheet 2 to reference cells from sheet 1. The difficulty I am having is that the cells in Sheet 1 are in a row (horizontally) and I need to reference them in a colum in sheet 2. Vertically. I was trying to use the transpose function but it wants to copy the formula to sheet 2. I am sure there is a simple way to do this but I have not had any luck.

**Bo_Ry** · 08-25-2019, 02:54 PM

Please try at C2

=INDEX('Sheet 1'!$B$14:$D$14,MATCH(B2,'Sheet 1'!$B$2:$D$2,))

Drag down

**popipipo** · 08-25-2019, 02:54 PM

Please Login or Register  to view this content.

Try this formula

**popipipo** · 08-25-2019, 02:55 PM

**surveyingdriller** · 08-25-2019, 03:23 PM

This worked very well. The exact sheet it was going on did not have the ABC reference so some modifications were made but this pointed me in the right direction. Thank You.

**surveyingdriller** · 08-25-2019, 03:24 PM

HDD Willem?

**popipipo** · 08-25-2019, 04:38 PM

sorry but what does HDD mean
I come from Holland and can't translate this

**surveyingdriller** · 08-25-2019, 04:44 PM

I know a person in Holland who's name is also Willem and works in an industry called HDD so I was curious if this was an incredidle coincidence

Thank you for the help. I have finished the worksheet now

**popipipo** · 08-25-2019, 04:48 PM

Sorry but that is not me

Do you know how many people in holland is called willem:

more then 100.000

https://www.vernoeming.nl/voornaam/willem

Need to reference cells from one sheet to another but in opposite direction - transpose???

LinkBack

Thread Tools

Rate This Thread

Display

Need to reference cells from one sheet to another but in opposite direction - transpose???

Re: Need to reference cells from one sheet to another but in opposite direction - transpos

Re: Need to reference cells from one sheet to another but in opposite direction - transpos

Re: Need to reference cells from one sheet to another but in opposite direction - transpos

Re: Need to reference cells from one sheet to another but in opposite direction - transpos

Re: Need to reference cells from one sheet to another but in opposite direction - transpos

Re: Need to reference cells from one sheet to another but in opposite direction - transpos

Re: Need to reference cells from one sheet to another but in opposite direction - transpos

Re: Need to reference cells from one sheet to another but in opposite direction - transpos

Thread Information

Users Browsing this Thread

Similar Threads

How to get digits in OPPOSITE direction

Finding cell reference in range (opposite to index match)

Rotating list of names (for a roster) need to move in opposite direction to examples seen

When dragging a formula, how to make it go opposite direction?

[SOLVED] Draw in same X-axis but two Y-axis in opposite direction in a same graph

Odd problam - keys move the opposite direction

Using Index and Match together as a combination for vlookup in the opposite direction

Bookmarks

Bookmarks

Posting Permissions