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

%3CLINGO-SUB%20id%3D%22lingo-sub-1356791%22%20slang%3D%22en-US%22%3EHow%20to%20use%20Vlookup%20results%20as%20a%20input%20for%20another%20vlookup%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1356791%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I%20have%20used%20vlookup%20on%20sheet_2%20to%20get%20a%20data%20from%20sheet1.%20Now%20I%20want%20to%20use%20Vlookup%20in%20sheet_3%20with%20the%20%22vlookup%20output%20from%20sheet_2%22.%20This%20gives%20me%20N%2FA%20results.%20Please%20tell%20me%20how%20to%20refer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1356791%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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

1 Reply
Highlighted

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