Excel VLOOKUP Multiple Sheets|General Excel Questions & Answers|Excel Forum|My Online Training Hub

i am using this formula and it works great. I’ve set up a test excel sheet just like your example. i set the searched range to be the entire sheet, of each sheet in the sheet list, and everything works well. However, if i move your chart on sheet two, to start at B1, the formula returns #N/A. if i cut and paste the chart back to A1, the proper values are returned. is there something that isnt allowing me to recognize the lookup value if it isn’t in column a? if so, how can i allow the formula to search the entire sheet for the lookup value?

i should clarify, i am going to be using this formula on a excel file of my own. in that file look up values could be anywhere within the sheet. So, i am hopeful there is a way to alter this formula to find the lookup value no matter where it is on the sheet.

i have attached two file. a working file where things are very similar to your example and a "not working" file where i have simply shifted one of the charts in sheet 2, thus returning #NA. i guess what i want is for the vlookup to search the entire sheet for a value and not just column A.