How to reference data from a seperate sheet

[chitty]

Hey guys i have a table of values that i want to be referenced by another table of values. How would i be able to do this.

bodyShapes.xlsx (6.7 KB)

I essentially want to be able to type in a bodytype number and have the armsize, torsosize and legsize read from the bodyTypes table and fill out those values accordingly

[robleyd]

The VLOOKUP function should do what you need.

[Wanderer]

And, if you really never referenced another sheet: you have to include the name of the sheet: Sheet1.$A$1:$A$100
.
Excel uses ! instead of the . but this is translated when you load files. Obviously INDIRECT may cause problems…

[mariosv]

A solution with an array formula like:

But seems it’s not compatible with Excel.
bodyShapes.xlsx (6.9 KB)

[sokol92]

@mariosv

But seems it’s not compatible with Excel

The same idea, compatible with Excel. Not array formula for H2:

=INDEX($B:$E;MATCH($G2;$A1:$A1000;0);COLUMN(B2)-1)

and drag to the right.