I have the following formula =VLOOKUP($A$6,'Functions and Headcount'!$A1:$AW38,7,FALSE)
I am in a worksheet called A
I understand looks for value in column A6 (A6 is based on a dropdown choice from A5) * I am guessing that it looks for this value in worksheet A
Next it searches for a matching value in the range A1:AW38 in worksheet called Functions and Headcount
then if it finds a match it places the value in what column and which worksheet A or Functions and Headcount?
Also what does the ! mean in the above VLOOKUP?
Thanks in advance