May 03 2020 09:13 PM
Hi I have used vlookup on sheet_2 to get a data from sheet1. Now I want to use Vlookup in sheet_3 with the "vlookup output from sheet_2". This gives me N/A results. Please tell me how to refer
May 03 2020 11:33 PM
This is smooth, you can take the sheet_2 formula and paste it to sheet_3 and you will see the sheet table reference is from sheet_1, you have to change it to sheet_name and required table array. Now you will get data from sheet_2 to sheet_3 which is already been fetched from sheet_1
If you changed the data in sheet_1 it results in changing sheet_2 & sheet_3 @dileeshcw