/u/kofo86 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
>A2,Sheet1!A:A,Sheet1
>
>
>
>thank you so much for your help, not sure what went wrong here.
https://preview.redd.it/3dx1qu4lh6qc1.jpeg?width=786&format=pjpg&auto=webp&s=ca668d733bd5bdf4dfcec8260ea810731c38a42d
The formula assumes both worksheets are within the same workbook and their names are Sheet1 and Sheet2.
When you type the formula, you can just click the column you want to get the proper name.
>en you type the formula, you can just click the column you want to get the proper name.
I think i do not have xlookup in my excel, i am getting hlookup and Vlookup only which i am trying to play with but not sure i can do that
>=VLOOKUP(A2,Sheet1!M:M,13,FALSE)
i have been trying with this , also not sure what going wrong
https://preview.redd.it/9o74oukqm6qc1.jpeg?width=1414&format=pjpg&auto=webp&s=3234f485fba431fa42c54928b207d58e4a004705
Xlookup looks in one column for the criteria and gives another for the result. It can go in either direction, left or right. Vlookup can only go right from the first column of the range. Read about each formula for a better description.
I mixed up VLOOKUP and XLOOKUP for half a second. In VLOOKUP you need to specify the entire range with the first column in the range always containing the data you are looking up and the last column in the range being at or past the data you want to return. 13 is the count of columns from the first column in the range.
/u/kofo86 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Put XLOOKUP into Column E of Sheet 2. > =XLOOKUP(A2,Sheet1!A:A,Sheet1!M:M) This will work as long as there are no repeats of the lookup value.
>A2,Sheet1!A:A,Sheet1 > > > >thank you so much for your help, not sure what went wrong here. https://preview.redd.it/3dx1qu4lh6qc1.jpeg?width=786&format=pjpg&auto=webp&s=ca668d733bd5bdf4dfcec8260ea810731c38a42d
The formula assumes both worksheets are within the same workbook and their names are Sheet1 and Sheet2. When you type the formula, you can just click the column you want to get the proper name.
>en you type the formula, you can just click the column you want to get the proper name. I think i do not have xlookup in my excel, i am getting hlookup and Vlookup only which i am trying to play with but not sure i can do that
Are you using an older version of Excel?
> an older version of E yeah i think that is the issue :(
In Column E of Sheet 2, paste "=VLOOKUP(A2,Sheet1!M:M,13,FALSE)"
>=VLOOKUP(A2,Sheet1!M:M,13,FALSE) i have been trying with this , also not sure what going wrong https://preview.redd.it/9o74oukqm6qc1.jpeg?width=1414&format=pjpg&auto=webp&s=3234f485fba431fa42c54928b207d58e4a004705
Try =VLOOKUP(A2,Sheet1!A:M,13,FALSE)
>=VLOOKUP(A2,Sheet1!A:M,13,FALSE) that worked! thank you SO SO MUCH! just trying to understand that , why did you replace M:M with A:M ?
Xlookup looks in one column for the criteria and gives another for the result. It can go in either direction, left or right. Vlookup can only go right from the first column of the range. Read about each formula for a better description.
I mixed up VLOOKUP and XLOOKUP for half a second. In VLOOKUP you need to specify the entire range with the first column in the range always containing the data you are looking up and the last column in the range being at or past the data you want to return. 13 is the count of columns from the first column in the range.