formula help please

T

tracker

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
OR in SUMPRODUCT formula 3
Multiple Variables in Conditional Formatting with Excel 2003 1
Summing cells based on mulitiple criteria over mulitple columns 0
Help with Formula 7
Using VBA To Enter A Sumproduct Formula Into A Cell 0
Formula Help-Excel 2007 2
i dont know if sumif ,,,,, please help 2

Top