I need to translate the values in one data range to the values in the other range because I have two data ranges. I'm probably doing a terrible job of describing this, but here's an illustration:

I have a range with standardized residuals (Range1):

1.7 0.6 -3.6
-1.5 -0.8 3.6
-0.2 0.2

And a second set of standardized residuals (Range2)

-2.6 1.7 0.7
1.5 -0.7 -0.7
1.2 -1.2

I take a bootstrapped sample from Range1 and get this output (BS1).

0.6 -3.6 -1.5 3.6
-0.2 0.6 -0.2
-0.2 -3.6
1.7

Now I want to use BS1 to get a bootstrapped sample of Range2 (BS2) by using the location of each BS1 value in Range1.

For example. BS1(1,1) = 0.6. That corresponds to Range1(1,2). So, BS2(1,1) = Range2(1,2) = 1.7. I want to end up with this table, BS2.

1.7 0.7 1.5 -0.7
1.2 1.7 1.2
1.2 0.7
-2.6

Can someone come up with a way to do this using formulas in Excel? VBA won't work for this. I'm hoping that makes things a little bit easier since, despite how unlikely it may sound, neither Range1 nor Range2 will have duplicate values.

Mar 27, 2023 in Others 685 views

## 1 answer to this question.

Try this:

```=IF(B4:H10<>"",B14:H20,"")
```

• 63,720 points

## How to give space between two Textfield in Flutter?

Hi@akhtar, There is various way to give space ...READ MORE

## Calculate time difference in hours between two dates and times

Simply subtract the two dates to get ...READ MORE

## SQL query to select dates between two dates

you should put those two dates between ...READ MORE

## Excel VLOOKUP between two sheets failing

Try this: =VLOOKUP(A2,'1'!\$A\$2:\$E\$811,5,0) I altered "1"! \$A\$2:\$A\$811 to '1'! ...READ MORE

## INDEX formula in Excel, Top 10, repeats previous value

Try this formula in cell W4: =IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX(\$I\$2:\$I\$26,MATCH(V4,\$R\$2:\$R\$26,0))) The calculation ...READ MORE

## Substring/Find last occurence of "/" and output everything to the right of it

Use TEXTAFTER() Function: =TEXTAFTER(B2,"/",-1) READ MORE