steve.waye
Board Regular
- Joined
- Jul 8, 2010
- Messages
- 68
Hi,
I have the following table on a spreadsheet...
I need to automatically insert a text string in the "Units" column based on the values in the "Course", "Elective" and "Stage" columns.
I have created the named range "Workplace_Delivery" on a hidden sheet as follows...
I'm using the equation below but I'm getting a #SPILL! error...
=VLOOKUP([Course]&[Elective]&[Stage],Workplace_Delivery,4,FALSE)
Any help would be appreciated.
I have the following table on a spreadsheet...
I need to automatically insert a text string in the "Units" column based on the values in the "Course", "Elective" and "Stage" columns.
I have created the named range "Workplace_Delivery" on a hidden sheet as follows...
I'm using the equation below but I'm getting a #SPILL! error...
=VLOOKUP([Course]&[Elective]&[Stage],Workplace_Delivery,4,FALSE)
Any help would be appreciated.