Question

Locked

Excel Table Question

By delboy ·
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.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Further To Excel Table Question

by delboy In reply to Excel Table Question

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

Collapse -

Re: Further To Excel Table Question

Go here for your info..

http://spreadsheets.about.com/od/excelfunctions/ss/if_function_sbs.htm

Please post back if you have any more problems or questions.
If this information is useful, please mark as helpful. Thanks.

Collapse -

Thanks

by delboy In reply to Re: Further To Excel Tabl ...

Thanks for your advice.
Much appreciated.

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums