A Anshum Manocha New Member Jun 11, 2021 #1 If I Enter data from the list (M1:M5) in cell number B5, then the data I want data to be upgraded from the File "Data" in the cells below as per Sheet Name. Thanks in Advance Attachments data.xlsx 742.5 KB · Views: 3 sOLUTION.xlsx 9.1 KB · Views: 1
If I Enter data from the list (M1:M5) in cell number B5, then the data I want data to be upgraded from the File "Data" in the cells below as per Sheet Name. Thanks in Advance
A Anshum Manocha New Member Jun 11, 2021 #2 I tried to go for VLOOKUP, but the formula will be long enough to check all cells
