Sheet3, A1:
Change $A$1:$Xx$Xx to accommodate your full range of cells, then copy right and down as far as needed.Formula:
=VLOOKUP(Sheet1!$A1,Sheet2!$A$1:$Xx$Xx,COLUMN(B1)-1,0)
Sheet3, A1:
Change $A$1:$Xx$Xx to accommodate your full range of cells, then copy right and down as far as needed.Formula:
=VLOOKUP(Sheet1!$A1,Sheet2!$A$1:$Xx$Xx,COLUMN(B1)-1,0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks