Forum Discussion
Formula
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 youThe following reasons why your formula does not work:
1) You are getting your Employee names into sheet2 through sheet10 using a VLOOKUP from column A in sheet1 Staff!$A$6:$A$204=IFERROR(VLOOKUP(Staff!$A$6:$A$204, Staff!$A$6:$C$204, 1, FALSE), "") ????
2) Then you get your statuses "E", or "C" into sheet1 by doing a VLOOKUP against Column A in sheet1 from sheet2 through sheet10 "Licence" column in sheet1 "Staff!sheet which results in a spilled range from sheet1
=VLOOKUP(A6,Licence!$A$2:$D$200,4,FALSE)
I am surprised that excel did not error out with a circular error message! The formula works in the first three cells but starts to cause frustration on the fourth cell. You need to change that before going forward.
cheers