I have a problem with my Xlookup formula can you tell me what I have done wrong? I have included some screenshots of what is happening. This formula worked fine until I moved the chart to another sheet named Charts. Now I get this N/A error. I have named the ranges of cells for the Systolic (E4:Q4) and Diastolic Pressures (D4:D13) as well as the return array (E5:Q13).
If you select a named range from the dropdown picker does it select the correct dataset?
Richard Van WagonerOP
@Reply 2 years ago
I am not quite sure what you mean. I don't have a dropdown picker, the information is typed in. and then looked up in the chart to a less than value hence the -1 in the formula.
Kevin Robertson
@Reply 2 years ago
Alex means the Name Box to the left of the Formula Bar.
Richard Van WagonerOP
@Reply 2 years ago
If I go to the chart and highlight the range it does say the correct name. This is true for the systolic range, diastolic range, and information range.
Kevin Robertson
@Reply 2 years ago
Yes, but when you select the name is the correct range selected in your sheet?
Click off the chart then select the name from the Name Box.
Richard Van WagonerOP
@Reply 2 years ago
Yes with all three
Richard Van WagonerOP
@Reply 2 years ago
I just found something with an error. It said that my range was proceeded by an apostrophe I changed that now it works.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Expert 11.
