Hi,
I have received a file that looks like the table below
------
A B C D E F
1 130 135 142
2 11 12 10
3 Y Z Y Z Y Z
4 1 1.3 1.8 1.1 3 1.4
5
6
7 "INPUT" "R 1L" "R 2L" "R 1R" "R 2R"
8 137.2 135 1.1 142 1.4

-------

the data provided goes to 200 columns, the rows are same as above.
I request for a formula for B8~E8.
"Input" data on A8,

Formula to search the adjacent data on Row 1 & search relative data from row
4.
"R 1L & R 1R" - search from Row 1 <data arranged in ascending order
"R 2L & R 2R" - search from Row 4.

Please inform if B8~E8 is possible to have a shorter formula.

regards,

tracker wrote:

Please inform if B8~E8 is possible to have a shorter formula.



Shorter than what?