on sheet1 of my workbook i want to insert data in a cell from the table on sheet2. The data is shown below.
It must start by checking if cell B4 has a measurement in it (eg. B4>0) before checking all the conditions in Sheet2 (“Table 4.2Valid”)(shown below):
it needs to check the information in the table as follows:-
(line1 or Line2 or line3 etc).
whichever line is correct it must display whatever is shown in the result column.
If no conditions are met, it must display the result in line6.
The table is on sheet2 OF MY EXCEL WORKBOOK and is called “4.2Valid” and is as follows:-
if short if long TTU? Result
1 NO YES YES 4.5
2 NO YES NO 4.5
3 YES NO YES 4.5
4 YES NO NO N/A
5 NO NO NO N/A
6 NO NO NO (LEAVE BLANK)
hope this makes sense.
Kind Regards
Del