M
momo2804
Hi there.......
I need some help with an Excel function, I did it several years ago
but now I've forgotten how its done. Support I have a range of values
in SheetA
Name Size
UserA 1.0
UserB 3.5
UserC 6.0
UserD 9.1
UserF 10
Then I have a lookup table in SheetB, what I want to do is lookup the
"Size" value in SheetA and return a given value
Size Setting
0.5 A
1.0 B
3.0 C
5.0 D
7.0 E
10 F
so what I want to do is for each row in SheetA lookup the table in
SheetB and see which size range the row falls into and return the
closest setting. Eg:
Name Size Setting
UserA 1.0 B
UserB 3.5 D
UserC 6.0 E
UserD 9.1 F
UserF 8.5 F
I want to compare the value in SheetA and return it to fall within the
ranges specified by the table in SheetB.
Many thanks
I need some help with an Excel function, I did it several years ago
but now I've forgotten how its done. Support I have a range of values
in SheetA
Name Size
UserA 1.0
UserB 3.5
UserC 6.0
UserD 9.1
UserF 10
Then I have a lookup table in SheetB, what I want to do is lookup the
"Size" value in SheetA and return a given value
Size Setting
0.5 A
1.0 B
3.0 C
5.0 D
7.0 E
10 F
so what I want to do is for each row in SheetA lookup the table in
SheetB and see which size range the row falls into and return the
closest setting. Eg:
Name Size Setting
UserA 1.0 B
UserB 3.5 D
UserC 6.0 E
UserD 9.1 F
UserF 8.5 F
I want to compare the value in SheetA and return it to fall within the
ranges specified by the table in SheetB.
Many thanks