stormania Member Feb 26, 2020 #1 Dear Master How to fill in recap data use a make a simple formula to vlookup data in multiple sheet? but not one by one vlookup per sheet As per data in attach file Thank in advance Attachments Multiple sheet.xlsx Multiple sheet.xlsx 19.9 KB · Views: 8
Dear Master How to fill in recap data use a make a simple formula to vlookup data in multiple sheet? but not one by one vlookup per sheet As per data in attach file Thank in advance
Juniad Active Member Feb 26, 2020 #2 In Recap sheet type in Cell C4 and drag over and down. =VLOOKUP($A4,INDIRECT("'"&C$3&"'!A2:C10"),3,0)
In Recap sheet type in Cell C4 and drag over and down. =VLOOKUP($A4,INDIRECT("'"&C$3&"'!A2:C10"),3,0)
Juniad Active Member Feb 27, 2020 #5 stormania said: Kindly help ..tq Click to expand... Because your 3rd column header and 3rd sheet name are not matched.. Change the column heading according to sheet name. Last edited: Feb 27, 2020
stormania said: Kindly help ..tq Click to expand... Because your 3rd column header and 3rd sheet name are not matched.. Change the column heading according to sheet name.
