Forum Discussion
Formula
Hi I'm creating a staff matrix training spreadsheet that shows when their licences & tickets expire & I want to be able to insert new staff members in alphabetical order on sheet 1 & their name carr...
Copy a) then Paste to cell B8:
a) =IFERROR(VLOOKUP(Licence!A8,$A$1:$P$195,COLUMN(B$1),0),"")
b) copy B8
c) Select cells C8 to cell P8
d) press enter
e) Select cells B8 to cell P8
f) copy
g) Select cells B9 to cells B195
h) press enter
cheers
Hi
I have tried this & didn't work for,
Licence is Column C on sheet 1
Beth is A4 on Licence sheet see attached.
give me a dummy workbook so I can put the formulas in.
replace the names with Name01, Name02, Name03...etc
I need the mapping on both sheets so I can reference the correct columns relative to each sheet with the correct column names
Hi
I have started another dummy, so only some of the sheets have a formula. Hope this helps. Thank you
