Help with Xlookup - Excel Expert 11 - Computer Learning Zone


	Back to Excel Expert 11 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Help with Xlookup

Richard Van Wagoner

14 months ago

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).

	Richard Van Wagoner OP @Reply 14 months ago

	Richard Van Wagoner OP @Reply 14 months ago

	Alex Hedley @Reply 14 months ago
If you select a named range from the dropdown picker does it select the correct dataset?

	Richard Van Wagoner OP @Reply 14 months 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 14 months ago
Alex means the Name Box to the left of the Formula Bar.

	Richard Van Wagoner OP @Reply 14 months 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 14 months 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 Wagoner OP @Reply 14 months ago
Yes with all three

	Richard Van Wagoner OP @Reply 14 months ago
I just found something with an error. It said that my range was proceeded by an apostrophe I changed that now it works.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Excel Expert 11.

Next Unseen