How to use Vlookup results as a input for another vlookup function

[dileeshcw]

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

[#2]

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