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
This conversation is currently closed to new comments.
Hi, I think I have come up with a solution to my Excel Table Problem as follows:- =IF(C4="Y",VLOOKUP(B4,Sheet2!D6:H9,3),IF(C4="N",VLOOKUP(B4,Sheet2!D6:H9,5)))
however when i use this formulae and none of the conditions are met, I want the cell in question (E4) to be blank. It currently displays 'FALSE'. What can I add to the above formulae so that when (B4) and (C4) are clear, then (E4) must also be blank? Kind Regards Del
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel Table Question
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