Forum Discussion

dileeshcw's avatar
dileeshcw
Copper Contributor
May 04, 2020

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

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

Excel
  • mplogace's avatar
    mplogace
    Copper Contributor
    May 04, 2020

    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 

Resources