Help with Xlookup - Excel Expert 11 - Computer Learning Zone


	Back to Excel Expert 11 Comments List

Upload Images @Reply Bookmark Link Email

Help with Xlookup

Richard Van Wagoner

8 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 8 months ago

	Richard Van Wagoner OP @Reply 8 months ago

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

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

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

	Richard Van Wagoner OP @Reply 8 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.